GCS Data Submission Data Load Data Source

➜ Back to Library
Description
Categories: BI Publisher
Application: Financial Consolidation Hub (Obsolete)
Source:
Short Name: GCS_DS_LOAD_SOURCE
DB package:
Run GCS Data Submission Data Load Data Source and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
AR Customer Credit Limits GCS A&D Trial Balance Data Source GCS Intercompany Matching Base Data Source GCS Data Submission Trial Balance Data Source GCS Intercompany Matching Data Source for Consolidation Entities GCS Intercompany Matching Base Data Source for Consolidation Entities GCS Consolidation Entries Base Data Source GCS Data Submission Data Load Base Data Source GCS Unmapped Data Submission Trial Balance Data Source
Blitz Report™

Blitz Report™ provides multiple benefits: