Product: | ITG - Internet Procurement Enterprise Connector |
---|---|
Description: | This view is used to generate XML at PO line distribution level for Sync PO message |
Implementation/DBA Data: | APPS.ITG_SP_PO_LINE_DIST_V |
SELECT PDA.PO_DISTRIBUTION_ID
, PDA.PO_HEADER_ID
, PDA.PO_LINE_ID
, PDA.LINE_LOCATION_ID
, PLLA.PRICE_OVERRIDE * PDA.QUANTITY_ORDERED OPERAMT_EXTENDED
, PHA.CURRENCY_CODE OPERAMT_CURRENCY
, PDA.QUANTITY_ORDERED OPERAMT_UOMVALUE
, UOM.UOM_CODE OPERAMT_UOM
, DECODE(ITG_X_UTILS.GETFLEXQUALIFIERSEGMENT( GCC.CHART_OF_ACCOUNTS_ID
, 'FA_COST_CTR' )
, 'SEGMENT1'
, GCC.SEGMENT1
, 'SEGMENT2'
, GCC.SEGMENT2
, 'SEGMENT3'
, GCC.SEGMENT3
, 'SEGMENT4'
, GCC.SEGMENT4
, 'SEGMENT5'
, GCC.SEGMENT5
, 'SEGMENT6'
, GCC.SEGMENT6
, 'SEGMENT7'
, GCC.SEGMENT7
, 'SEGMENT8'
, GCC.SEGMENT8
, 'SEGMENT9'
, GCC.SEGMENT9
, 'SEGMENT10'
, GCC.SEGMENT10
, 'SEGMENT11'
, GCC.SEGMENT11
, 'SEGMENT12'
, GCC.SEGMENT12
, 'SEGMENT13'
, GCC.SEGMENT13
, 'SEGMENT14'
, GCC.SEGMENT14
, 'SEGMENT15'
, GCC.SEGMENT15
, 'SEGMENT16'
, GCC.SEGMENT16
, 'SEGMENT17'
, GCC.SEGMENT17
, 'SEGMENT18'
, GCC.SEGMENT18
, 'SEGMENT19'
, GCC.SEGMENT19
, 'SEGMENT20'
, GCC.SEGMENT20
, 'SEGMENT21'
, GCC.SEGMENT21
, 'SEGMENT22'
, GCC.SEGMENT22
, 'SEGMENT23'
, GCC.SEGMENT23
, 'SEGMENT24'
, GCC.SEGMENT24
, 'SEGMENT25'
, GCC.SEGMENT25
, 'SEGMENT26'
, GCC.SEGMENT26
, 'SEGMENT27'
, GCC.SEGMENT27
, 'SEGMENT28'
, GCC.SEGMENT28
, 'SEGMENT29'
, GCC.SEGMENT29
, 'SEGMENT30'
, GCC.SEGMENT30) COSTCENTER
, GCC.SEGMENT1 ELEMENT1
, GCC.SEGMENT2 ELEMENT2
, GCC.SEGMENT3 ELEMENT3
, GCC.SEGMENT4 ELEMENT4
, GCC.SEGMENT5 ELEMENT5
, GCC.SEGMENT6 ELEMENT6
, GCC.SEGMENT7 ELEMENT7
, GCC.SEGMENT8 ELEMENT8
, GCC.SEGMENT9 ELEMENT9
, GCC.SEGMENT10 ELEMENT10
, GCC.SEGMENT11 ELEMENT11
, GCC.SEGMENT12 ELEMENT12
, GCC.SEGMENT13 ELEMENT13
, GCC.SEGMENT14 ELEMENT14
, GCC.SEGMENT15 ELEMENT15
, GCC.SEGMENT16 ELEMENT16
, GCC.SEGMENT17 ELEMENT17
, GCC.SEGMENT18 ELEMENT18
, GCC.SEGMENT19 ELEMENT19
, GCC.SEGMENT20 ELEMENT20
, GCC.SEGMENT21 ELEMENT21
, GCC.SEGMENT22 ELEMENT22
, GCC.SEGMENT23 ELEMENT23
, GCC.SEGMENT24 ELEMENT24
, GCC.SEGMENT25 ELEMENT25
, GCC.SEGMENT26 ELEMENT26
, GCC.SEGMENT27 ELEMENT27
, GCC.SEGMENT28 ELEMENT28
, GCC.SEGMENT29 ELEMENT29
, GCC.SEGMENT30 ELEMENT30
, TO_CHAR(ORGDEF.SET_OF_BOOKS_ID) GLENTITYS
, DECODE(ITG_X_UTILS.GETFLEXQUALIFIERSEGMENT( GCC.CHART_OF_ACCOUNTS_ID
, 'GL_ACCOUNT' )
, 'SEGMENT1'
, GCC.SEGMENT1
, 'SEGMENT2'
, GCC.SEGMENT2
, 'SEGMENT3'
, GCC.SEGMENT3
, 'SEGMENT4'
, GCC.SEGMENT4
, 'SEGMENT5'
, GCC.SEGMENT5
, 'SEGMENT6'
, GCC.SEGMENT6
, 'SEGMENT7'
, GCC.SEGMENT7
, 'SEGMENT8'
, GCC.SEGMENT8
, 'SEGMENT9'
, GCC.SEGMENT9
, 'SEGMENT10'
, GCC.SEGMENT10
, 'SEGMENT11'
, GCC.SEGMENT11
, 'SEGMENT12'
, GCC.SEGMENT12
, 'SEGMENT13'
, GCC.SEGMENT13
, 'SEGMENT14'
, GCC.SEGMENT14
, 'SEGMENT15'
, GCC.SEGMENT15
, 'SEGMENT16'
, GCC.SEGMENT16
, 'SEGMENT17'
, GCC.SEGMENT17
, 'SEGMENT18'
, GCC.SEGMENT18
, 'SEGMENT19'
, GCC.SEGMENT19
, 'SEGMENT20'
, GCC.SEGMENT20
, 'SEGMENT21'
, GCC.SEGMENT21
, 'SEGMENT22'
, GCC.SEGMENT22
, 'SEGMENT23'
, GCC.SEGMENT23
, 'SEGMENT24'
, GCC.SEGMENT24
, 'SEGMENT25'
, GCC.SEGMENT25
, 'SEGMENT26'
, GCC.SEGMENT26
, 'SEGMENT27'
, GCC.SEGMENT27
, 'SEGMENT28'
, GCC.SEGMENT28
, 'SEGMENT29'
, GCC.SEGMENT29
, 'SEGMENT30'
, GCC.SEGMENT30) GLNOMACCT
, TO_CHAR(PDA.PROJECT_ID) PROJECT
, ORGDEF.ORGANIZATION_NAME UNIT
, TO_CHAR(PDA.PO_DISTRIBUTION_ID) UA_DISTRID
, TO_CHAR(PDA.LINE_LOCATION_ID) UA_SCHEDLID
, TO_CHAR(PDA.DISTRIBUTION_NUM) UA_LINENUM
, PER.EMPLOYEE_NUMBER UA_DELIVERTO
, PDA.ATTRIBUTE1 UA_DIST_ATTR1
, PDA.ATTRIBUTE2 UA_DIST_ATTR2
, PDA.ATTRIBUTE3 UA_DIST_ATTR3
, PDA.ATTRIBUTE4 UA_DIST_ATTR4
, PDA.ATTRIBUTE5 UA_DIST_ATTR5
, PDA.ATTRIBUTE6 UA_DIST_ATTR6
, PDA.ATTRIBUTE7 UA_DIST_ATTR7
, PDA.ATTRIBUTE8 UA_DIST_ATTR8
, PDA.ATTRIBUTE9 UA_DIST_ATTR9
, PDA.ATTRIBUTE10 UA_DIST_ATTR10
, PDA.ATTRIBUTE11 UA_DIST_ATTR11
, PDA.ATTRIBUTE12 UA_DIST_ATTR12
, PDA.ATTRIBUTE13 UA_DIST_ATTR13
, PDA.ATTRIBUTE14 UA_DIST_ATTR14
, PDA.ATTRIBUTE15 UA_DIST_ATTR15
, ITG_X_UTILS.GETREQUISTNID(PDA.REQ_DISTRIBUTION_ID) UA_REQUISITNID
, ITG_X_UTILS.GETREQLINENUM(PDA.REQ_DISTRIBUTION_ID) UA_REQLINENUM
FROM GL_CODE_COMBINATIONS GCC
, MTL_UNITS_OF_MEASURE UOM
, ORG_ORGANIZATION_DEFINITIONS ORGDEF
, PER_PEOPLE_F PER
, PO_LINE_LOCATIONS_ALL PLLA
, PO_DISTRIBUTIONS_ALL PDA
, PO_HEADERS_ALL PHA
WHERE GCC.CODE_COMBINATION_ID = PDA.CODE_COMBINATION_ID
AND ORGDEF.ORGANIZATION_ID (+) = PDA.DESTINATION_ORGANIZATION_ID
AND PLLA.LINE_LOCATION_ID (+) = PDA.LINE_LOCATION_ID
AND PHA.PO_HEADER_ID = PDA.PO_HEADER_ID
AND PER.PERSON_ID (+) = PDA.DELIVER_TO_PERSON_ID
AND UOM.UNIT_OF_MEASURE (+) = PLLA.UNIT_MEAS_LOOKUP_CODE
AND PDA.LINE_LOCATION_ID IS NOT NULL
AND NVL(PER.EFFECTIVE_END_DATE
, SYSDATE+1) > SYSDATE