View: ITG_REQ_DISTRIBUTIONS_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This view is used for generating XML at requisition distribution level
Implementation/DBA Data:	APPS.ITG_REQ_DISTRIBUTIONS_V

View Text

SELECT LA.REQUISITION_HEADER_ID
, LA.REQUISITION_LINE_ID REQ_LINE_ID
, D.DISTRIBUTION_NUM DISTRIBUTION_NUM
, D.REQ_LINE_QUANTITY QUANTITY_ITEM
, CC.SEGMENT1 PROPERTY1
, CC.SEGMENT2 PROPERTY2
, CC.SEGMENT3 PROPERTY3
, CC.SEGMENT4 PROPERTY4
, CC.SEGMENT5 PROPERTY5
, CC.SEGMENT6 PROPERTY6
, CC.SEGMENT7 PROPERTY7
, CC.SEGMENT8 PROPERTY8
, CC.SEGMENT9 PROPERTY9
, CC.SEGMENT10 PROPERTY10
, CC.SEGMENT11 PROPERTY11
, CC.SEGMENT12 PROPERTY12
, CC.SEGMENT13 PROPERTY13
, CC.SEGMENT14 PROPERTY14
, CC.SEGMENT15 PROPERTY15
, CC.SEGMENT16 PROPERTY16
, CC.SEGMENT17 PROPERTY17
, CC.SEGMENT18 PROPERTY18
, CC.SEGMENT19 PROPERTY19
, CC.SEGMENT20 PROPERTY20
, CC.SEGMENT21 PROPERTY21
, CC.SEGMENT22 PROPERTY22
, CC.SEGMENT23 PROPERTY23
, CC.SEGMENT24 PROPERTY24
, CC.SEGMENT25 PROPERTY25
, CC.SEGMENT26 PROPERTY26
, CC.SEGMENT27 PROPERTY27
, CC.SEGMENT28 PROPERTY28
, CC.SEGMENT29 PROPERTY29
, CC.SEGMENT30 PROPERTY30
, DECODE ( LA.ITEM_ID
, NULL
, NULL
, ITG_X_UTILS.SEGSTRING ( 401
, 'MSTK'
, NULL
, MI.SEGMENT1
, MI.SEGMENT2
, MI.SEGMENT3
, MI.SEGMENT4
, MI.SEGMENT5
, MI.SEGMENT6
, MI.SEGMENT7
, MI.SEGMENT8
, MI.SEGMENT9
, MI.SEGMENT10
, MI.SEGMENT11
, MI.SEGMENT12
, MI.SEGMENT13
, MI.SEGMENT14
, MI.SEGMENT15
, MI.SEGMENT16
, MI.SEGMENT17
, MI.SEGMENT18
, MI.SEGMENT19
, MI.SEGMENT20 ) ) DISTRIBUTION_ITEM
, LA.ITEM_DESCRIPTION DESCRIPTN
, D.ATTRIBUTE1 DISTLINE_UA_ATTRIBUTE1
, D.ATTRIBUTE2 DISTLINE_UA_ATTRIBUTE2
, D.ATTRIBUTE3 DISTLINE_UA_ATTRIBUTE3
, D.ATTRIBUTE4 DISTLINE_UA_ATTRIBUTE4
, D.ATTRIBUTE5 DISTLINE_UA_ATTRIBUTE5
, D.ATTRIBUTE6 DISTLINE_UA_ATTRIBUTE6
, D.ATTRIBUTE7 DISTLINE_UA_ATTRIBUTE7
, D.ATTRIBUTE8 DISTLINE_UA_ATTRIBUTE8
, D.ATTRIBUTE9 DISTLINE_UA_ATTRIBUTE9
, D.ATTRIBUTE10 DISTLINE_UA_ATTRIBUTE10
, D.ATTRIBUTE11 DISTLINE_UA_ATTRIBUTE11
, D.ATTRIBUTE12 DISTLINE_UA_ATTRIBUTE12
, D.ATTRIBUTE13 DISTLINE_UA_ATTRIBUTE13
, D.ATTRIBUTE14 DISTLINE_UA_ATTRIBUTE14
, D.ATTRIBUTE15 DISTLINE_UA_ATTRIBUTE15
FROM GL_CODE_COMBINATIONS CC
, PO_REQ_DISTRIBUTIONS_ALL D
, PO_REQUISITION_LINES_ALL LA
, MTL_SYSTEM_ITEMS MI
WHERE CC.CODE_COMBINATION_ID = D.CODE_COMBINATION_ID
AND D.REQUISITION_LINE_ID = LA.REQUISITION_LINE_ID
AND MI.INVENTORY_ITEM_ID (+) = LA.ITEM_ID
AND MI.ORGANIZATION_ID (+) = LA.ORG_ID

Columns