VIEW: APPS.ITG_REQ_DISTRIBUTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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