eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XLA_PSA_BC_LINES_V

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_PSA_BC_LINES_V

View Text

SELECT L.LEDGER_ID
, L.EVENT_ID
, L.ENTITY_ID
, L.AE_HEADER_ID
, L.AE_LINE_NUM
, L.BALANCE_TYPE_CODE
, L.ACCOUNTING_DATE
, L.PERIOD_NAME
, L.JE_CATEGORY_NAME
, L.BUDGET_VERSION_ID
, L.ENCUMBRANCE_TYPE_ID
, L.CODE_COMBINATION_ID
, L.ENTERED_CURRENCY_CODE
, L.ENTERED_DR
, L.ENTERED_CR
, L.ACCOUNTED_DR
, L.ACCOUNTED_CR
, D.BFLOW_APPLICATION_ID APPLY_TO_APPLICATION_ID
, D.BFLOW_ENTITY_CODE APPLY_TO_ENTITY_CODE
, D.BFLOW_SOURCE_ID_NUM_1 APPLY_TO_SOURCE_ID_INT_1
, D.BFLOW_SOURCE_ID_NUM_2 APPLY_TO_SOURCE_ID_INT_2
, D.BFLOW_SOURCE_ID_NUM_3 APPLY_TO_SOURCE_ID_INT_3
, D.BFLOW_SOURCE_ID_NUM_4 APPLY_TO_SOURCE_ID_INT_4
, D.BFLOW_SOURCE_ID_CHAR_1 APPLY_TO_SOURCE_ID_CHAR_1
, D.BFLOW_SOURCE_ID_CHAR_2 APPLY_TO_SOURCE_ID_CHAR_2
, D.BFLOW_SOURCE_ID_CHAR_3 APPLY_TO_SOURCE_ID_CHAR_3
, D.BFLOW_SOURCE_ID_CHAR_4 APPLY_TO_SOURCE_ID_CHAR_4
, D.BFLOW_DISTRIBUTION_TYPE APPLY_TO_DIST_TYPE
, D.BFLOW_DIST_ID_NUM_1 APPLY_TO_DIST_ID_NUM_1
, D.BFLOW_DIST_ID_NUM_2 APPLY_TO_DIST_ID_NUM_2
, D.BFLOW_DIST_ID_NUM_3 APPLY_TO_DIST_ID_NUM_3
, D.BFLOW_DIST_ID_NUM_4 APPLY_TO_DIST_ID_NUM_4
, D.BFLOW_DIST_ID_NUM_5 APPLY_TO_DIST_ID_NUM_5
, D.BFLOW_DIST_ID_CHAR_1 APPLY_TO_DIST_ID_CHAR_1
, D.BFLOW_DIST_ID_CHAR_2 APPLY_TO_DIST_ID_CHAR_2
, D.BFLOW_DIST_ID_CHAR_3 APPLY_TO_DIST_ID_CHAR_3
, D.BFLOW_DIST_ID_CHAR_4 APPLY_TO_DIST_ID_CHAR_4
, D.BFLOW_DIST_ID_CHAR_5 APPLY_TO_DIST_ID_CHAR_5
, D.SOURCE_DISTRIBUTION_TYPE
, D.SOURCE_DISTRIBUTION_ID_CHAR_1
, D.SOURCE_DISTRIBUTION_ID_CHAR_2
, D.SOURCE_DISTRIBUTION_ID_CHAR_3
, D.SOURCE_DISTRIBUTION_ID_CHAR_4
, D.SOURCE_DISTRIBUTION_ID_CHAR_5
, D.SOURCE_DISTRIBUTION_ID_NUM_1
, D.SOURCE_DISTRIBUTION_ID_NUM_2
, D.SOURCE_DISTRIBUTION_ID_NUM_3
, D.SOURCE_DISTRIBUTION_ID_NUM_4
, D.SOURCE_DISTRIBUTION_ID_NUM_5
FROM XLA_VALIDATION_LINES_GT L
, XLA_AE_LINES_GT D
WHERE D.AE_HEADER_ID = L.AE_HEADER_ID
AND D.AE_LINE_NUM = L.AE_LINE_NUM
AND L.ACCOUNTING_ENTRY_STATUS_CODE = 0
AND L.BALANCING_LINE_TYPE IN ('P'
, 'C')

Columns

Name
LEDGER_ID
EVENT_ID
ENTITY_ID
AE_HEADER_ID
AE_LINE_NUM
BALANCE_TYPE_CODE
ACCOUNTING_DATE
PERIOD_NAME
JE_CATEGORY_NAME
BUDGET_VERSION_ID
ENCUMBRANCE_TYPE_ID
CODE_COMBINATION_ID
ENTERED_CURRENCY_CODE
ENTERED_DR
ENTERED_CR
ACCOUNTED_DR
ACCOUNTED_CR
APPLY_TO_APPLICATION_ID
APPLY_TO_ENTITY_CODE
APPLY_TO_SOURCE_ID_INT_1
APPLY_TO_SOURCE_ID_INT_2
APPLY_TO_SOURCE_ID_INT_3
APPLY_TO_SOURCE_ID_INT_4
APPLY_TO_SOURCE_ID_CHAR_1
APPLY_TO_SOURCE_ID_CHAR_2
APPLY_TO_SOURCE_ID_CHAR_3
APPLY_TO_SOURCE_ID_CHAR_4
APPLY_TO_DIST_TYPE
APPLY_TO_DIST_ID_NUM_1
APPLY_TO_DIST_ID_NUM_2
APPLY_TO_DIST_ID_NUM_3
APPLY_TO_DIST_ID_NUM_4
APPLY_TO_DIST_ID_NUM_5
APPLY_TO_DIST_ID_CHAR_1
APPLY_TO_DIST_ID_CHAR_2
APPLY_TO_DIST_ID_CHAR_3
APPLY_TO_DIST_ID_CHAR_4
APPLY_TO_DIST_ID_CHAR_5
SOURCE_DISTRIBUTION_TYPE
SOURCE_DISTRIBUTION_ID_CHAR_1
SOURCE_DISTRIBUTION_ID_CHAR_2
SOURCE_DISTRIBUTION_ID_CHAR_3
SOURCE_DISTRIBUTION_ID_CHAR_4
SOURCE_DISTRIBUTION_ID_CHAR_5
SOURCE_DISTRIBUTION_ID_NUM_1
SOURCE_DISTRIBUTION_ID_NUM_2
SOURCE_DISTRIBUTION_ID_NUM_3
SOURCE_DISTRIBUTION_ID_NUM_4
SOURCE_DISTRIBUTION_ID_NUM_5