VIEW: APPS.ICX_REQ_DIST_UPDATE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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