VIEW: PO.PO_BC_DISTRIBUTIONS#

Source

View Text - Preformatted

select PACKET_ID PACKET_ID, AE_EVENT_ID AE_EVENT_ID, STATUS_CODE STATUS_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, GL_DATE GL_DATE, LEDGER_ID LEDGER_ID, CURRENCY_CODE CURRENCY_CODE, JE_SOURCE_NAME JE_SOURCE_NAME, JE_CATEGORY_NAME JE_CATEGORY_NAME, ENTERED_AMT ENTERED_AMT, ACCOUNTED_AMT ACCOUNTED_AMT, CODE_COMBINATION_ID CODE_COMBINATION_ID, DISTRIBUTION_TYPE DISTRIBUTION_TYPE, HEADER_ID HEADER_ID, DISTRIBUTION_ID DISTRIBUTION_ID, SEQUENCE_NUMBER SEQUENCE_NUMBER, SEGMENT1 SEGMENT1, REFERENCE_NUMBER REFERENCE_NUMBER, APPLIED_TO_APPL_ID APPLIED_TO_APPL_ID, APPLIED_TO_DIST_LINK_TYPE APPLIED_TO_DIST_LINK_TYPE, APPLIED_TO_DIST_ID_1 APPLIED_TO_DIST_ID_1, APPLIED_TO_DIST_ID_2 APPLIED_TO_DIST_ID_2, APPLIED_TO_DIST_ID_3 APPLIED_TO_DIST_ID_3, APPLIED_TO_DIST_ID_4 APPLIED_TO_DIST_ID_4, APPLIED_TO_DIST_ID_5 APPLIED_TO_DIST_ID_5, PA_PROJECT_ID PA_PROJECT_ID, PA_AWARD_ID PA_AWARD_ID, PA_TASK_ID PA_TASK_ID, PA_EXP_ORG_ID PA_EXP_ORG_ID, PA_EXP_TYPE PA_EXP_TYPE, PA_EXP_ITEM_DATE PA_EXP_ITEM_DATE, BC_DISTRIBUTION_ID BC_DISTRIBUTION_ID, EVENT_TYPE_CODE EVENT_TYPE_CODE, MAIN_OR_BACKING_CODE MAIN_OR_BACKING_CODE, JE_LINE_DESCRIPTION JE_LINE_DESCRIPTION, BACKING_DIST_ENTERED_AMT BACKING_DIST_ENTERED_AMT, BACKING_DIST_ACCOUNTED_AMT BACKING_DIST_ACCOUNTED_AMT, PO_RELEASE_ID PO_RELEASE_ID, LINE_ID LINE_ID, LINE_LOCATION_ID LINE_LOCATION_ID, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, LINE_NUMBER LINE_NUMBER, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REFERENCE1 REFERENCE1, REFERENCE2 REFERENCE2, REFERENCE3 REFERENCE3, REFERENCE4 REFERENCE4, REFERENCE5 REFERENCE5, REFERENCE6 REFERENCE6, REFERENCE7 REFERENCE7, REFERENCE8 REFERENCE8, REFERENCE9 REFERENCE9, REFERENCE10 REFERENCE10, REFERENCE11 REFERENCE11, REFERENCE12 REFERENCE12, REFERENCE13 REFERENCE13, REFERENCE14 REFERENCE14, REFERENCE15 REFERENCE15, APPLIED_TO_ENTITY_CODE APPLIED_TO_ENTITY_CODE, APPLIED_TO_HEADER_ID_1 APPLIED_TO_HEADER_ID_1, APPLIED_TO_HEADER_ID_2 APPLIED_TO_HEADER_ID_2, APPLIED_TO_HEADER_ID_3 APPLIED_TO_HEADER_ID_3, APPLIED_TO_HEADER_ID_4 APPLIED_TO_HEADER_ID_4, ADJUSTMENT_STATUS ADJUSTMENT_STATUS, ORIGIN_SEQUENCE_NUM ORIGIN_SEQUENCE_NUM, ONLINE_REPORT_ID ONLINE_REPORT_ID, CLM_DOC_FLAG CLM_DOC_FLAG from "PO"."PO_BC_DISTRIBUTIONS"

View Text - HTML Formatted

SELECT PACKET_ID PACKET_ID
, AE_EVENT_ID AE_EVENT_ID
, STATUS_CODE STATUS_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, GL_DATE GL_DATE
, LEDGER_ID LEDGER_ID
, CURRENCY_CODE CURRENCY_CODE
, JE_SOURCE_NAME JE_SOURCE_NAME
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, ENTERED_AMT ENTERED_AMT
, ACCOUNTED_AMT ACCOUNTED_AMT
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, DISTRIBUTION_TYPE DISTRIBUTION_TYPE
, HEADER_ID HEADER_ID
, DISTRIBUTION_ID DISTRIBUTION_ID
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, SEGMENT1 SEGMENT1
, REFERENCE_NUMBER REFERENCE_NUMBER
, APPLIED_TO_APPL_ID APPLIED_TO_APPL_ID
, APPLIED_TO_DIST_LINK_TYPE APPLIED_TO_DIST_LINK_TYPE
, APPLIED_TO_DIST_ID_1 APPLIED_TO_DIST_ID_1
, APPLIED_TO_DIST_ID_2 APPLIED_TO_DIST_ID_2
, APPLIED_TO_DIST_ID_3 APPLIED_TO_DIST_ID_3
, APPLIED_TO_DIST_ID_4 APPLIED_TO_DIST_ID_4
, APPLIED_TO_DIST_ID_5 APPLIED_TO_DIST_ID_5
, PA_PROJECT_ID PA_PROJECT_ID
, PA_AWARD_ID PA_AWARD_ID
, PA_TASK_ID PA_TASK_ID
, PA_EXP_ORG_ID PA_EXP_ORG_ID
, PA_EXP_TYPE PA_EXP_TYPE
, PA_EXP_ITEM_DATE PA_EXP_ITEM_DATE
, BC_DISTRIBUTION_ID BC_DISTRIBUTION_ID
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, MAIN_OR_BACKING_CODE MAIN_OR_BACKING_CODE
, JE_LINE_DESCRIPTION JE_LINE_DESCRIPTION
, BACKING_DIST_ENTERED_AMT BACKING_DIST_ENTERED_AMT
, BACKING_DIST_ACCOUNTED_AMT BACKING_DIST_ACCOUNTED_AMT
, PO_RELEASE_ID PO_RELEASE_ID
, LINE_ID LINE_ID
, LINE_LOCATION_ID LINE_LOCATION_ID
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, LINE_NUMBER LINE_NUMBER
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REFERENCE1 REFERENCE1
, REFERENCE2 REFERENCE2
, REFERENCE3 REFERENCE3
, REFERENCE4 REFERENCE4
, REFERENCE5 REFERENCE5
, REFERENCE6 REFERENCE6
, REFERENCE7 REFERENCE7
, REFERENCE8 REFERENCE8
, REFERENCE9 REFERENCE9
, REFERENCE10 REFERENCE10
, REFERENCE11 REFERENCE11
, REFERENCE12 REFERENCE12
, REFERENCE13 REFERENCE13
, REFERENCE14 REFERENCE14
, REFERENCE15 REFERENCE15
, APPLIED_TO_ENTITY_CODE APPLIED_TO_ENTITY_CODE
, APPLIED_TO_HEADER_ID_1 APPLIED_TO_HEADER_ID_1
, APPLIED_TO_HEADER_ID_2 APPLIED_TO_HEADER_ID_2
, APPLIED_TO_HEADER_ID_3 APPLIED_TO_HEADER_ID_3
, APPLIED_TO_HEADER_ID_4 APPLIED_TO_HEADER_ID_4
, ADJUSTMENT_STATUS ADJUSTMENT_STATUS
, ORIGIN_SEQUENCE_NUM ORIGIN_SEQUENCE_NUM
, ONLINE_REPORT_ID ONLINE_REPORT_ID
, CLM_DOC_FLAG CLM_DOC_FLAG
FROM "PO"."PO_BC_DISTRIBUTIONS"