VIEW: APPS.FEM_BALANCES_V

Source

View Text - Preformatted

SELECT b.DATASET_CODE ,b.CAL_PERIOD_ID ,b.CREATION_ROW_SEQUENCE ,b.SOURCE_SYSTEM_CODE ,b.LEDGER_ID ,b.COMPANY_COST_CENTER_ORG_ID ,b.CURRENCY_CODE ,b.CURRENCY_TYPE_CODE ,b.ACTIVITY_ID ,b.COST_OBJECT_ID ,b.FINANCIAL_ELEM_ID ,b.PRODUCT_ID ,b.NATURAL_ACCOUNT_ID ,b.CHANNEL_ID ,b.LINE_ITEM_ID ,b.PROJECT_ID ,b.CUSTOMER_ID ,b.ENTITY_ID ,b.INTERCOMPANY_ID ,b.TASK_ID ,b.USER_DIM1_ID ,b.USER_DIM2_ID ,b.USER_DIM3_ID ,b.USER_DIM4_ID ,b.USER_DIM5_ID ,b.USER_DIM6_ID ,b.USER_DIM7_ID ,b.USER_DIM8_ID ,b.USER_DIM9_ID ,b.USER_DIM10_ID ,b.CREATED_BY_REQUEST_ID ,b.CREATED_BY_OBJECT_ID ,b.LAST_UPDATED_BY_REQUEST_ID ,b.LAST_UPDATED_BY_OBJECT_ID ,b.XTD_BALANCE_E ,b.XTD_BALANCE_F ,b.YTD_BALANCE_E ,b.YTD_BALANCE_F ,b.QTD_BALANCE_E ,b.QTD_BALANCE_F ,b.PTD_DEBIT_BALANCE_E ,b.PTD_CREDIT_BALANCE_E ,b.YTD_DEBIT_BALANCE_E ,b.YTD_CREDIT_BALANCE_E ,vs.FUNCTIONAL_CURRENCY_CODE ,vs.CALENDAR_ID ,vs.COMPANY_COST_CENTER_ORG_VS_ID ,vs.FINANCIAL_ELEM_VS_ID ,vs.PRODUCT_VS_ID ,vs.NATURAL_ACCOUNT_VS_ID ,vs.CHANNEL_VS_ID ,vs.LINE_ITEM_VS_ID ,vs.PROJECT_VS_ID ,vs.CUSTOMER_VS_ID ,vs.ENTITY_VS_ID ,vs.TASK_VS_ID ,vs.USER_DIM1_VS_ID ,vs.USER_DIM2_VS_ID ,vs.USER_DIM3_VS_ID ,vs.USER_DIM4_VS_ID ,vs.USER_DIM5_VS_ID ,vs.USER_DIM6_VS_ID ,vs.USER_DIM7_VS_ID ,vs.USER_DIM8_VS_ID ,vs.USER_DIM9_VS_ID ,vs.USER_DIM10_VS_ID from FEM_BALANCES b ,FEM_LEDGER_DIM_VS_MAPS vs WHERE vs.ledger_id = b.ledger_id

View Text - HTML Formatted

SELECT B.DATASET_CODE
, B.CAL_PERIOD_ID
, B.CREATION_ROW_SEQUENCE
, B.SOURCE_SYSTEM_CODE
, B.LEDGER_ID
, B.COMPANY_COST_CENTER_ORG_ID
, B.CURRENCY_CODE
, B.CURRENCY_TYPE_CODE
, B.ACTIVITY_ID
, B.COST_OBJECT_ID
, B.FINANCIAL_ELEM_ID
, B.PRODUCT_ID
, B.NATURAL_ACCOUNT_ID
, B.CHANNEL_ID
, B.LINE_ITEM_ID
, B.PROJECT_ID
, B.CUSTOMER_ID
, B.ENTITY_ID
, B.INTERCOMPANY_ID
, B.TASK_ID
, B.USER_DIM1_ID
, B.USER_DIM2_ID
, B.USER_DIM3_ID
, B.USER_DIM4_ID
, B.USER_DIM5_ID
, B.USER_DIM6_ID
, B.USER_DIM7_ID
, B.USER_DIM8_ID
, B.USER_DIM9_ID
, B.USER_DIM10_ID
, B.CREATED_BY_REQUEST_ID
, B.CREATED_BY_OBJECT_ID
, B.LAST_UPDATED_BY_REQUEST_ID
, B.LAST_UPDATED_BY_OBJECT_ID
, B.XTD_BALANCE_E
, B.XTD_BALANCE_F
, B.YTD_BALANCE_E
, B.YTD_BALANCE_F
, B.QTD_BALANCE_E
, B.QTD_BALANCE_F
, B.PTD_DEBIT_BALANCE_E
, B.PTD_CREDIT_BALANCE_E
, B.YTD_DEBIT_BALANCE_E
, B.YTD_CREDIT_BALANCE_E
, VS.FUNCTIONAL_CURRENCY_CODE
, VS.CALENDAR_ID
, VS.COMPANY_COST_CENTER_ORG_VS_ID
, VS.FINANCIAL_ELEM_VS_ID
, VS.PRODUCT_VS_ID
, VS.NATURAL_ACCOUNT_VS_ID
, VS.CHANNEL_VS_ID
, VS.LINE_ITEM_VS_ID
, VS.PROJECT_VS_ID
, VS.CUSTOMER_VS_ID
, VS.ENTITY_VS_ID
, VS.TASK_VS_ID
, VS.USER_DIM1_VS_ID
, VS.USER_DIM2_VS_ID
, VS.USER_DIM3_VS_ID
, VS.USER_DIM4_VS_ID
, VS.USER_DIM5_VS_ID
, VS.USER_DIM6_VS_ID
, VS.USER_DIM7_VS_ID
, VS.USER_DIM8_VS_ID
, VS.USER_DIM9_VS_ID
, VS.USER_DIM10_VS_ID
FROM FEM_BALANCES B
, FEM_LEDGER_DIM_VS_MAPS VS
WHERE VS.LEDGER_ID = B.LEDGER_ID