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: PA_XLA_BC_PKT_AP_DETAIL_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_XLA_BC_PKT_AP_DETAIL_V

View Text

SELECT PBC.BC_EVENT_ID
, PBC.SOURCE_EVENT_ID
, PBC.DOCUMENT_DISTRIBUTION_ID
, PBC.DOCUMENT_DISTRIBUTION_ID
, PBC.EXPENDITURE_TYPE AID_EXPENDITURE_TYPE
, PBC.BC_PACKET_ID
, PBC.BUDGET_VERSION_ID
, DECODE(PBC.DOCUMENT_TYPE
, 'AP'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'PREPAY APPL'
, NVL(PBC.ACCOUNTED_CR
, 0) - NVL(PBC.ACCOUNTED_DR
, 0)
, 'PREPAY APPL NONREC TAX'
, NVL(PBC.ACCOUNTED_CR
, 0) - NVL(PBC.ACCOUNTED_DR
, 0)
, NVL(PBC.ACCOUNTED_DR
, 0) - NVL(PBC.ACCOUNTED_CR
, 0))
, NVL(PBC.ACCOUNTED_CR
, 0) - NVL(PBC.ACCOUNTED_DR
, 0)) AID_BASE_AMT_NO_ROUND
, DECODE(PBC.DOCUMENT_TYPE
, 'AP'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'PREPAY APPL'
, NVL(PBC.ENTERED_CR
, 0) - NVL(PBC.ENTERED_DR
, 0)
, 'PREPAY APPL NONREC TAX'
, NVL(PBC.ENTERED_CR
, 0) - NVL(PBC.ENTERED_DR
, 0)
, NVL(PBC.ENTERED_DR
, 0) - NVL(PBC.ENTERED_CR
, 0))
, NVL(PBC.ENTERED_CR
, 0) - NVL(PBC.ENTERED_DR
, 0)) AID_AMOUNT
, DECODE(PBC.DOCUMENT_TYPE
, 'PO'
, 'PA_PO_BURDEN'
, 'AP'
, 'PA_AP_BURDEN') DISTRIBUTION_LINK_TYPE
, PBC.PROJECT_ID AID_PROJECT_ID
, PBC.TASK_ID AID_TASK_ID
, PBC.EXPENDITURE_ORGANIZATION_ID AID_EXPENDITURE_ORG_ID
, PBC.EXPENDITURE_ITEM_DATE AID_EXPENDITURE_ITEM_DATE
, PBC.ENCUMBRANCE_TYPE_ID
, PBC.PROJ_ENCUMBRANCE_TYPE_ID
, GLL.CURRENCY_CODE AI_INVOICE_CURRENCY_CODE
, GLL.CURRENCY_CODE
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, PBC.BUDGET_CCID
, PBC.DOCUMENT_TYPE
, PBC.DOCUMENT_HEADER_ID AI_INVOICE_ID
, PRLM.EVENT_TYPE
, PRLM.EXPENDITURE_CATEGORY
, PRLM.REVENUE_CATEGORY
, PRLM.PERSON_ID
, PRLM.JOB_ID
, PBC.VENDOR_ID
, PBC.PACKET_ID
, PBC.PARENT_BC_PACKET_ID
, PBC.SET_OF_BOOKS_ID
, PBC.BURDEN_COST_FLAG
, PA_FUNDS_CONTROL_UTILS.GET_SLA_NOTUPGRADED_FLAG (DECODE(DOCUMENT_TYPE
, 'AP'
, 200
, 'PO'
, 201)
, DECODE(DOCUMENT_TYPE
, 'AP'
, 'AP_INVOICES'
, 'PO'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, 'RELEASE'
, 'BLANKET'
, 'RELEASE'
, 'PURCHASE_ORDER'))
, DECODE(DOCUMENT_TYPE
, 'AP'
, PBC.DOCUMENT_HEADER_ID
, 'PO'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, PBC.DOCUMENT_HEADER_ID_2
, 'BLANKET'
, PBC.DOCUMENT_HEADER_ID_2
, PBC.DOCUMENT_HEADER_ID))
, PBC.DOCUMENT_DISTRIBUTION_ID
, DECODE(DOCUMENT_TYPE
, 'AP'
, 'AP_INV_DIST'
, 'PO'
, 'PO_DISTRIBUTIONS_ALL')
, PBC.BUDGET_VERSION_ID
, PBC.BUDGET_LINE_ID) USE_ENC_UPG_ATTRIB_FLAG /* FOR AP
, ONLY NON-BUDGET CREDIT JLT'S ARE PO/REL RELIEVING
AND PREPAY APPL. HENCE FOR CREDIT JLT
, DR WILL HOLD BUDGET DETAILS
AND CR WILL HOLD TRANSACTION DETAILS*/
, DECODE(PBC.DOCUMENT_TYPE
, 'AP'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'PREPAY APPL'
, 'PA_BUDGET_ENC'
, 'PREPAY APPL NONREC TAX'
, 'PA_BUDGET_ENC'
, DECODE(BURDEN_METHOD_CODE
, 'S'
, 'AP_INV_PA_BURDENED'
, 'D'
, 'AP_INV_PA_BURDEN'
, NULL))
, 'PO'
, 'PA_BUDGET_ENC') ENC_UPG_DR_ACCT_CLASS
, DECODE(PBC.DOCUMENT_TYPE
, 'AP'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'PREPAY APPL'
, DECODE(BURDEN_METHOD_CODE
, 'S'
, 'AP_INV_PA_BURDENED'
, 'D'
, 'AP_INV_PA_BURDEN'
, NULL)
, 'PREPAY APPL NONREC TAX'
, DECODE(BURDEN_METHOD_CODE
, 'S'
, 'AP_INV_PA_BURDENED'
, 'D'
, 'AP_INV_PA_BURDEN'
, NULL)
, 'PA_BUDGET_ENC' )
, 'PO'
, DECODE(BURDEN_METHOD_CODE
, 'S'
, 'PO_PA_BURDENED'
, 'D'
, 'PO_PA_BURDEN'
, NULL)) ENC_UPG_CR_ACCT_CLASS
, PBC.BUDGET_CCID ENC_UPG_DR_ACCOUNT
, PBC.BUDGET_CCID ENC_UPG_CR_ACCOUNT
, DECODE(PBC.DOCUMENT_TYPE
, 'AP'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'PREPAY APPL'
, PBC.PROJ_ENCUMBRANCE_TYPE_ID
, 'PREPAY APPL NONREC TAX'
, PBC.PROJ_ENCUMBRANCE_TYPE_ID
, PBC.ENCUMBRANCE_TYPE_ID)
, 'PO'
, PBC.PROJ_ENCUMBRANCE_TYPE_ID ) ENC_UPG_DR_ENC_TYPE_ID
, DECODE(PBC.DOCUMENT_TYPE
, 'AP'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'PREPAY APPL'
, PBC.ENCUMBRANCE_TYPE_ID
, 'PREPAY APPL NONREC TAX'
, PBC.ENCUMBRANCE_TYPE_ID
, PBC.PROJ_ENCUMBRANCE_TYPE_ID )
, 'PO'
, PBC.ENCUMBRANCE_TYPE_ID) ENC_UPG_CR_ENC_TYPE_ID
, DECODE(DOCUMENT_TYPE
, 'PO'
, 201
, NULL)
, DECODE(DOCUMENT_TYPE
, 'PO'
, 'PA_PO_BURDEN'
, NULL)
, DECODE(DOCUMENT_TYPE
, 'PO'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, 'RELEASE'
, 'BLANKET'
, 'RELEASE'
, 'PURCHASE_ORDER')
, NULL)
, DECODE(DOCUMENT_TYPE
, 'PO'
, PBC.DOCUMENT_DISTRIBUTION_ID
, NULL)
, DECODE(DOCUMENT_TYPE
, 'PO'
, PBC.EXPENDITURE_TYPE
, NULL)
, DECODE(DOCUMENT_TYPE
, 'PO'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, PBC.DOCUMENT_HEADER_ID_2
, 'BLANKET'
, PBC.DOCUMENT_HEADER_ID_2
, PBC.DOCUMENT_HEADER_ID)
, NULL)
, DECODE(DOCUMENT_TYPE
, 'AP'
, 200
, NULL)
, DECODE(DOCUMENT_TYPE
, 'AP'
, 'PA_AP_BURDEN'
, NULL)
, DECODE(DOCUMENT_TYPE
, 'AP'
, 'AP_INVOICES'
, NULL)
, DECODE(DOCUMENT_TYPE
, 'AP'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'PREPAY APPL'
, TO_NUMBER(PBC.REFERENCE3)
, 'PREPAY APPL NONREC TAX'
, TO_NUMBER(PBC.REFERENCE3)
, PBC.DOCUMENT_DISTRIBUTION_ID)
, NULL)
, DECODE(DOCUMENT_TYPE
, 'AP'
, PBC.EXPENDITURE_TYPE
, NULL)
, DECODE(DOCUMENT_TYPE
, 'AP'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'PREPAY APPL'
, TO_NUMBER(PBC.REFERENCE2)
, 'PREPAY APPL NONREC TAX'
, TO_NUMBER(PBC.REFERENCE2)
, PBC.DOCUMENT_HEADER_ID)
, NULL)
, 275
, 'PA_BUDGET_ENC'
, 'BUDGETS'
, BUDGET_LINE_ID
, NULL
, BUDGET_VERSION_ID
, 200
, DECODE(SUBSTR(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 1
, 11)
, 'PREPAY APPL'
, 'AP_PREPAY'
, 'AP_INV_DIST')
, 'AP_INVOICES'
, (DECODE(PBC.DOCUMENT_TYPE
, 'PO'
, DECODE(PBC.REFERENCE1
, 'AP'
, TO_NUMBER(PBC.REFERENCE2)
, PBC.DOCUMENT_HEADER_ID)
, PBC.DOCUMENT_HEADER_ID))
, ( SELECT DECODE(SUBSTR(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 1
, 11)
, 'PREPAY APPL'
, (SELECT PREPAY_APP_DIST_ID
FROM AP_PREPAY_APP_DISTS
WHERE BC_EVENT_ID = APD.BC_EVENT_ID
AND PREPAY_APP_DISTRIBUTION_ID = APD.INVOICE_DISTRIBUTION_ID
AND ROWNUM = 1 )
, COALESCE(APD.CHARGE_APPLICABLE_TO_DIST_ID
, APD.RELATED_ID
, APD.INVOICE_DISTRIBUTION_ID))
FROM AP_INVOICE_DISTRIBUTIONS_ALL APD
WHERE APD.INVOICE_DISTRIBUTION_ID = DECODE(PBC.DOCUMENT_TYPE
, 'PO'
, DECODE(PBC.REFERENCE1
, 'AP'
, TO_NUMBER(PBC.REFERENCE3)
, PBC.DOCUMENT_DISTRIBUTION_ID)
, PBC.DOCUMENT_DISTRIBUTION_ID)) ALLOC_TO_FIRST_DIST_ID
, NULL
, DECODE(DOCUMENT_TYPE
, 'PO'
, DECODE(PBC.DOCUMENT_DISTRIBUTION_TYPE
, 'SCHEDULED'
, PBC.DOCUMENT_HEADER_ID_2
, 'BLANKET'
, PBC.DOCUMENT_HEADER_ID_2
, NULL)
, NULL)
, DOCUMENT_DISTRIBUTION_TYPE
, TXN_CCID AI_DIST_CCID
, DECODE(DOCUMENT_TYPE
, 'AP'
, DECODE(PA_FUNDS_CONTROL_UTILS.GET_AP_ACCT_REVERSAL_ATTR(XEV.EVENT_TYPE_CODE
, PBC.DOCUMENT_DISTRIBUTION_ID
, PBC.DOCUMENT_DISTRIBUTION_TYPE)
, NULL
, 'N'
, 'Y')
, 'N') ACCT_REVERSAL_INDICATOR
, DECODE(DOCUMENT_TYPE
, 'AP'
, PA_FUNDS_CONTROL_UTILS.GET_AP_ACCT_REVERSAL_ATTR(XEV.EVENT_TYPE_CODE
, PBC.DOCUMENT_DISTRIBUTION_ID
, PBC.DOCUMENT_DISTRIBUTION_TYPE)
, TO_NUMBER(NULL)) ACCT_REVERSAL_FIRST_DIST_ID
, DECODE(DOCUMENT_TYPE
, 'AP'
, 'PA_AP_BURDEN'
, NULL) ACCT_REV_DISTRIBUTION_TYPE
FROM PA_BC_PACKETS PBC
, XLA_EVENTS_GT XEV
, PA_RESOURCE_LIST_MEMBERS PRLM
, GL_LEDGERS GLL
WHERE XEV.EVENT_ID = PBC.BC_EVENT_ID
AND PBC.DOCUMENT_TYPE IN ('PO'
, 'AP')
AND PBC.RESOURCE_LIST_MEMBER_ID = PRLM.RESOURCE_LIST_MEMBER_ID
AND PBC.BURDEN_COST_FLAG IN ('N'
, 'O')
AND PBC.SET_OF_BOOKS_ID = GLL.LEDGER_ID
AND PBC.STATUS_CODE = 'I'

Columns

Name
EVENT_ID
SOURCE_EVENT_ID
LINE_NUMBER
AID_INVOICE_DIST_ID
AID_EXPENDITURE_TYPE
BC_PACKET_ID
BUDGET_VERSION_ID
AID_BASE_AMT_NO_ROUND
AID_AMOUNT
DISTRIBUTION_LINK_TYPE
AID_PROJECT_ID
AID_TASK_ID
AID_EXPENDITURE_ORG_ID
AID_EXPENDITURE_ITEM_DATE
UPG_ENC_TYPE_ID
UPG_PROJ_ENC_TYPE_ID
AI_INVOICE_CURRENCY_CODE
LEDGER_CURRENCY
INV_EXCHANGE_RATE_TYPE
INV_EXCHANGE_DATE
INV_EXCHANGE_RATE
BUDGET_CCID
DOCUMENT_TYPE
AI_INVOICE_ID
REV_EVENT_TYPE
EXPENDITURE_CATEGORY
REVENUE_CATEGORY
PERSON_ID
JOB_ID
POV_VENDOR_ID
PACKET_ID
PARENT_BC_PACKET_ID
LEDGER_ID
BURDEN_COST_FLAG
USE_ENC_UPG_ATTRIB_FLAG
ENC_UPG_DR_ACCT_CLASS
ENC_UPG_CR_ACCT_CLASS
ENC_UPG_DR_ACCOUNT
ENC_UPG_CR_ACCOUNT
ENC_UPG_DR_ENC_TYPE_ID
ENC_UPG_CR_ENC_TYPE_ID
PO_APPLICATION_ID
PO_DISTRIBUTION_TYPE
PO_ENTITY_CODE
PO_FIRST_DIST_ID
PO_SECOND_DIST_ID
PO_FIRST_SYS_TRANS_ID
AP_APPLICATION_ID
AP_DISTRIBUTION_TYPE
AP_ENTITY_CODE
AP_FIRST_DIST_ID
AP_SECOND_DIST_ID
AP_FIRST_SYS_TRANS_ID
PA_APPLICATION_ID
PA_DISTRIBUTION_TYPE
PA_ENTITY_CODE
PA_FIRST_DIST_ID
PA_SECOND_DIST_ID
PA_FIRST_SYS_TRANS_ID
ALLOC_TO_APPLN_ID
ALLOC_TO_DIST_TYPE
ALLOC_TO_ENTITY_CODE
ALLOC_TO_FIRST_SYS_TRANS_ID
ALLOC_TO_FIRST_DIST_ID
ALLOC_TO_SECOND_DIST_ID
PO_RELEASE_ID
DOCUMENT_DISTRIBUTION_TYPE
AID_DIST_CCID
ACCT_REVERSAL_INDICATOR
ACCT_REVERSAL_FIRST_DIST_ID
ACCT_REV_DISTRIBUTION_TYPE