Product: | ICX - Oracle iProcurement |
---|---|
Description: | Account Distribution Lines View |
Implementation/DBA Data: | APPS.ICX_REQ_DIST_UPDATE_V |
SELECT PORD.REQUISITION_LINE_ID CART_LINE_ID
, DISTRIBUTION_ID
, DISTRIBUTION_NUM
, PORD.LAST_UPDATED_BY
, PORD.LAST_UPDATE_DATE
, PORD.LAST_UPDATE_LOGIN
, PORD.CREATION_DATE
, PORD.CREATED_BY
, PORD.CODE_COMBINATION_ID CHARGE_ACCOUNT_ID
, GLCC.SEGMENT1 CHARGE_ACCOUNT_SEGMENT1
, GLCC.SEGMENT2 CHARGE_ACCOUNT_SEGMENT2
, GLCC.SEGMENT3 CHARGE_ACCOUNT_SEGMENT3
, GLCC.SEGMENT4 CHARGE_ACCOUNT_SEGMENT4
, GLCC.SEGMENT5 CHARGE_ACCOUNT_SEGMENT5
, GLCC.SEGMENT6 CHARGE_ACCOUNT_SEGMENT6
, GLCC.SEGMENT7 CHARGE_ACCOUNT_SEGMENT7
, GLCC.SEGMENT8 CHARGE_ACCOUNT_SEGMENT8
, GLCC.SEGMENT9 CHARGE_ACCOUNT_SEGMENT9
, GLCC.SEGMENT10 CHARGE_ACCOUNT_SEGMENT10
, GLCC.SEGMENT11 CHARGE_ACCOUNT_SEGMENT11
, GLCC.SEGMENT12 CHARGE_ACCOUNT_SEGMENT12
, GLCC.SEGMENT13 CHARGE_ACCOUNT_SEGMENT13
, GLCC.SEGMENT14 CHARGE_ACCOUNT_SEGMENT14
, GLCC.SEGMENT15 CHARGE_ACCOUNT_SEGMENT15
, GLCC.SEGMENT16 CHARGE_ACCOUNT_SEGMENT16
, GLCC.SEGMENT17 CHARGE_ACCOUNT_SEGMENT17
, GLCC.SEGMENT18 CHARGE_ACCOUNT_SEGMENT18
, GLCC.SEGMENT19 CHARGE_ACCOUNT_SEGMENT19
, GLCC.SEGMENT20 CHARGE_ACCOUNT_SEGMENT20
, GLCC.SEGMENT21 CHARGE_ACCOUNT_SEGMENT21
, GLCC.SEGMENT22 CHARGE_ACCOUNT_SEGMENT22
, GLCC.SEGMENT23 CHARGE_ACCOUNT_SEGMENT23
, GLCC.SEGMENT24 CHARGE_ACCOUNT_SEGMENT24
, GLCC.SEGMENT25 CHARGE_ACCOUNT_SEGMENT25
, GLCC.SEGMENT26 CHARGE_ACCOUNT_SEGMENT26
, GLCC.SEGMENT27 CHARGE_ACCOUNT_SEGMENT27
, GLCC.SEGMENT28 CHARGE_ACCOUNT_SEGMENT28
, GLCC.SEGMENT29 CHARGE_ACCOUNT_SEGMENT29
, GLCC.SEGMENT30 CHARGE_ACCOUNT_SEGMENT30
, PORD.ATTRIBUTE_CATEGORY DIST_ATTRIBUTE_CATEGORY
, PORD.ATTRIBUTE1 DISTRIBUTION_ATTRIBUTE1
, PORD.ATTRIBUTE2 DISTRIBUTION_ATTRIBUTE2
, PORD.ATTRIBUTE3 DISTRIBUTION_ATTRIBUTE3
, PORD.ATTRIBUTE4 DISTRIBUTION_ATTRIBUTE4
, PORD.ATTRIBUTE5 DISTRIBUTION_ATTRIBUTE5
, PORD.ATTRIBUTE6 DISTRIBUTION_ATTRIBUTE6
, PORD.ATTRIBUTE7 DISTRIBUTION_ATTRIBUTE7
, PORD.ATTRIBUTE8 DISTRIBUTION_ATTRIBUTE8
, PORD.ATTRIBUTE9 DISTRIBUTION_ATTRIBUTE9
, PORD.ATTRIBUTE10 DISTRIBUTION_ATTRIBUTE10
, PORD.ATTRIBUTE11 DISTRIBUTION_ATTRIBUTE11
, PORD.ATTRIBUTE12 DISTRIBUTION_ATTRIBUTE12
, PORD.ATTRIBUTE13 DISTRIBUTION_ATTRIBUTE13
, PORD.ATTRIBUTE14 DISTRIBUTION_ATTRIBUTE14
, PORD.ATTRIBUTE15 DISTRIBUTION_ATTRIBUTE15
, ACCRUAL_ACCOUNT_ID
, VARIANCE_ACCOUNT_ID
, BUDGET_ACCOUNT_ID
, PORD.ORG_ID
, PORH.REQUISITION_HEADER_ID CART_ID
, ALLOCATION_TYPE
, ALLOCATION_VALUE
, PORD.REQ_LINE_QUANTITY ALLOCATION_QUANTITY
, GLCC.CONCATENATED_SEGMENTS CHARGE_ACCOUNT_NUM
FROM GL_CODE_COMBINATIONS_KFV GLCC
, PO_REQ_DISTRIBUTIONS_ALL PORD
, PO_REQUISITION_LINES_ALL PORL
, PO_REQUISITION_HEADERS_ALL PORH
WHERE PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID (+)
AND PORL.REQUISITION_LINE_ID = PORD.REQUISITION_LINE_ID (+)
AND PORD.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID