GCS Data Submission Data Load Data Source Copy link
Description
- Categories
- BI Publisher
- Application
- Financial Consolidation Hub (Obsolete)
- Source
- Short Name
- GCS_DS_LOAD_SOURCE
DB package:
SQL 96 lines
SELECT gbit.cctr_org_display_code ORGANIZATION, gbit.line_item_display_code LINEITEM, /*startSelectList*/ gbit.FINANCIAL_ELEM_DISPLAY_CODE financial_elem_name , gbit.NATURAL_ACCOUNT_DISPLAY_CODE natural_account_name , gbit.PRODUCT_DISPLAY_CODE product_name , gbit.PROJECT_DISPLAY_CODE project_name , gbit.TASK_DISPLAY_CODE task_name , gbit.USER_DIM1_DISPLAY_CODE user_dim1_name , /*endSelectList*/ gbit.intercompany_display_code INTERCOMPANY, to_char(gbit.ptd_debit_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))) ptd_debit_balance_e, to_char(gbit.ptd_credit_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))) ptd_credit_balance_e, to_char(gbit.ytd_debit_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))) ytd_debit_balance_e, to_char(gbit.ytd_credit_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))) ytd_credit_balance_e, nvl(to_char(gbit.ptd_debit_balance_f, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))), to_char(gbit.ptd_debit_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50)))) ptd_debit_balance_f, nvl(to_char(gbit.ptd_credit_balance_f, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))), to_char(gbit.ptd_credit_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50)))) ptd_credit_balance_f, nvl(to_char(gbit.ytd_debit_balance_f, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))), to_char(gbit.ytd_debit_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50)))) ytd_debit_balance_f, nvl(to_char(gbit.ytd_credit_balance_f, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))), to_char(gbit.ytd_credit_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50)))) ytd_credit_balance_f, to_char(gbit.ptd_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))) ptd_balance_e, to_char(gbit.ytd_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))) ytd_balance_e, nvl(to_char(gbit.ptd_balance_f, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))), to_char(gbit.ptd_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50)))) ptd_balance_f, nvl(to_char(gbit.ytd_balance_f, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50))), to_char(gbit.ytd_balance_e, nvl(:format_mask, fnd_currency.safe_get_format_mask(gbit.currency_code, 50)))) ytd_balance_f, fct.name currency_name1, dbms_lob.substr(gbit.error_message_code) error_message_code, gcs_drilldown_util_pkg.url_encode(gbit.rowid) rowids FROM gcs_bal_interface_t gbit, fnd_currencies_tl fct WHERE load_id = :pXmlFileId AND gbit.currency_code = fct.currency_code(+) AND fct.language(+) = userenv('LANG') ORDER BY gbit.cctr_org_display_code, gbit.line_item_display_code, /*startOrderClause*/ gbit.LINE_ITEM_DISPLAY_CODE, gbit.FINANCIAL_ELEM_DISPLAY_CODE, gbit.NATURAL_ACCOUNT_DISPLAY_CODE, gbit.PRODUCT_DISPLAY_CODE, gbit.PROJECT_DISPLAY_CODE, gbit.TASK_DISPLAY_CODE, gbit.USER_DIM1_DISPLAY_CODE, /*endOrderClause*/ gbit.intercompany_display_code |