GCS Data Submission Data Load Data Source

Description
Categories: BI Publisher
Application: Financial Consolidation Hub (Obsolete)
Source:
Short Name: GCS_DS_LOAD_SOURCE
DB package:
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