VIEW: APPS.GCS_DYN_TB_V

Source

View Text - Preformatted

SELECT  fb.dataset_code,  fb.cal_period_id,  fb.entity_id,  fb.ledger_id,  fb.currency_code,  fb.currency_type_code,  fb.source_system_code,  fb.company_cost_center_org_id,  fb.intercompany_id,  fb.line_item_id,  fb.financial_elem_id,  fb.product_id,  fb.natural_account_id,  fb.channel_id,  fb.project_id,  fb.customer_id,  fb.task_id,  fb.user_dim1_id,  fb.user_dim2_id,  fb.user_dim3_id,  fb.user_dim4_id,  fb.user_dim5_id,  fb.user_dim6_id,  fb.user_dim7_id,  fb.user_dim8_id,  fb.user_dim9_id,  fb.user_dim10_id,  cotl.company_cost_center_org_name,  ictl.company_cost_center_org_name intercompany_name,  litl.line_item_name,  null financial_elem_name,  null product_name,  null natural_account_name,  null channel_name,  null project_name,  null customer_name,  null task_name,  null user_dim1_name,  null user_dim2_name,  null user_dim3_name,  null user_dim4_name,  null user_dim5_name,  null user_dim6_name,  null user_dim7_name,  null user_dim8_name,  null user_dim9_name,  null user_dim10_name,  cotl.description company_cost_center_org_desc,  ictl.description intercompany_desc,  litl.description line_item_desc,  null financial_elem_desc,  null product_desc,  null natural_account_desc,  null channel_desc,  null project_desc,  null customer_desc,  null task_desc,  null user_dim1_desc,  null user_dim2_desc,  null user_dim3_desc,  null user_dim4_desc,  null user_dim5_desc,  null user_dim6_desc,  null user_dim7_desc,  null user_dim8_desc,  null user_dim9_desc,  null user_dim10_desc,  fb.xtd_balance_e,  fb.xtd_balance_f,  fb.ytd_balance_e,  fb.ytd_balance_f FROM  FEM_BALANCES fb,  FEM_CCTR_ORGS_TL cotl,  FEM_CCTR_ORGS_TL ictl,  FEM_LN_ITEMS_TL litl WHERE cotl.company_cost_center_org_id = fb.company_cost_center_org_id AND   cotl.language = userenv('LANG') AND   ictl.company_cost_center_org_id = fb.intercompany_id AND   ictl.language = userenv('LANG') AND   litl.line_item_id = fb.line_item_id AND   litl.language = userenv('LANG') AND   fb.currency_type_code IN ('ENTERED', 'TRANSLATED') 

View Text - HTML Formatted

SELECT FB.DATASET_CODE
, FB.CAL_PERIOD_ID
, FB.ENTITY_ID
, FB.LEDGER_ID
, FB.CURRENCY_CODE
, FB.CURRENCY_TYPE_CODE
, FB.SOURCE_SYSTEM_CODE
, FB.COMPANY_COST_CENTER_ORG_ID
, FB.INTERCOMPANY_ID
, FB.LINE_ITEM_ID
, FB.FINANCIAL_ELEM_ID
, FB.PRODUCT_ID
, FB.NATURAL_ACCOUNT_ID
, FB.CHANNEL_ID
, FB.PROJECT_ID
, FB.CUSTOMER_ID
, FB.TASK_ID
, FB.USER_DIM1_ID
, FB.USER_DIM2_ID
, FB.USER_DIM3_ID
, FB.USER_DIM4_ID
, FB.USER_DIM5_ID
, FB.USER_DIM6_ID
, FB.USER_DIM7_ID
, FB.USER_DIM8_ID
, FB.USER_DIM9_ID
, FB.USER_DIM10_ID
, COTL.COMPANY_COST_CENTER_ORG_NAME
, ICTL.COMPANY_COST_CENTER_ORG_NAME INTERCOMPANY_NAME
, LITL.LINE_ITEM_NAME
, NULL FINANCIAL_ELEM_NAME
, NULL PRODUCT_NAME
, NULL NATURAL_ACCOUNT_NAME
, NULL CHANNEL_NAME
, NULL PROJECT_NAME
, NULL CUSTOMER_NAME
, NULL TASK_NAME
, NULL USER_DIM1_NAME
, NULL USER_DIM2_NAME
, NULL USER_DIM3_NAME
, NULL USER_DIM4_NAME
, NULL USER_DIM5_NAME
, NULL USER_DIM6_NAME
, NULL USER_DIM7_NAME
, NULL USER_DIM8_NAME
, NULL USER_DIM9_NAME
, NULL USER_DIM10_NAME
, COTL.DESCRIPTION COMPANY_COST_CENTER_ORG_DESC
, ICTL.DESCRIPTION INTERCOMPANY_DESC
, LITL.DESCRIPTION LINE_ITEM_DESC
, NULL FINANCIAL_ELEM_DESC
, NULL PRODUCT_DESC
, NULL NATURAL_ACCOUNT_DESC
, NULL CHANNEL_DESC
, NULL PROJECT_DESC
, NULL CUSTOMER_DESC
, NULL TASK_DESC
, NULL USER_DIM1_DESC
, NULL USER_DIM2_DESC
, NULL USER_DIM3_DESC
, NULL USER_DIM4_DESC
, NULL USER_DIM5_DESC
, NULL USER_DIM6_DESC
, NULL USER_DIM7_DESC
, NULL USER_DIM8_DESC
, NULL USER_DIM9_DESC
, NULL USER_DIM10_DESC
, FB.XTD_BALANCE_E
, FB.XTD_BALANCE_F
, FB.YTD_BALANCE_E
, FB.YTD_BALANCE_F
FROM FEM_BALANCES FB
, FEM_CCTR_ORGS_TL COTL
, FEM_CCTR_ORGS_TL ICTL
, FEM_LN_ITEMS_TL LITL
WHERE COTL.COMPANY_COST_CENTER_ORG_ID = FB.COMPANY_COST_CENTER_ORG_ID
AND COTL.LANGUAGE = USERENV('LANG')
AND ICTL.COMPANY_COST_CENTER_ORG_ID = FB.INTERCOMPANY_ID
AND ICTL.LANGUAGE = USERENV('LANG')
AND LITL.LINE_ITEM_ID = FB.LINE_ITEM_ID
AND LITL.LANGUAGE = USERENV('LANG')
AND FB.CURRENCY_TYPE_CODE IN ('ENTERED'
, 'TRANSLATED')