View: ITG_SP_REL_POLINE_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This view is used to generate the PO release line segment in the Sync PO Release XML
Implementation/DBA Data:	APPS.ITG_SP_REL_POLINE_V

View Text

SELECT PLA.PO_HEADER_ID
, PLA.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, R.PO_RELEASE_ID
, PLL.PRICE_OVERRIDE UNIT_AMOUNT
, PHA.CURRENCY_CODE UNIT_CURRENCY
, PLL.QUANTITY UNIT_QUANTITY
, UOM.UOM_CODE UNIT_UOM
, PLA.QUANTITY ORDERED_QUANTITY
, TO_CHAR(PLL.SHIPMENT_NUM) POLINENUM
, DECODE(PLA.CATEGORY_ID
, NULL
, NULL
, ITG_X_UTILS.SEGSTRING( 401
, 'MCAT'
, CAT.STRUCTURE_ID
, CAT.SEGMENT1
, CAT.SEGMENT2
, CAT.SEGMENT3
, CAT.SEGMENT4
, CAT.SEGMENT5
, CAT.SEGMENT6
, CAT.SEGMENT7
, CAT.SEGMENT8
, CAT.SEGMENT9
, CAT.SEGMENT10
, CAT.SEGMENT11
, CAT.SEGMENT12
, CAT.SEGMENT13
, CAT.SEGMENT14
, CAT.SEGMENT15
, CAT.SEGMENT16
, CAT.SEGMENT17
, CAT.SEGMENT18
, CAT.SEGMENT19
, CAT.SEGMENT20)) COMMODITY
, (SELECT SEGMENT1
FROM PO_HEADERS_ALL
WHERE PO_HEADER_ID=PLA.CONTRACT_ID) CONTRACTS
, PHA.FREIGHT_TERMS_LOOKUP_CODE FRGHTCLS
, HAZTL.HAZARD_CLASS HAZRDMATL
, PLA.ITEM_REVISION ITEMRV
, PLA.ITEM_DESCRIPTION ITEMTYPE
, PLA.NOTE_TO_VENDOR NOTES
, TO_CHAR(PLA.ORG_ID) POENTITY
, DECODE(PLA.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)) ITEM
, PLA.VENDOR_PRODUCT_NUM ITEMX
, DECODE(PHA.AUTHORIZATION_STATUS
, 'APPROVED'
, 'OPEN'
, 'REQUIRES REAPPROVAL'
, 'HOLD'
, NULL) UA_REF_STATUS
, DECODE(MI.INVENTORY_ITEM_FLAG
, 'Y'
, 'N'
, 'Y') UA_REF_EXP
, PLL.ATTRIBUTE1 UA_REF_ATTR
, PLL.ATTRIBUTE1 UA_LINE_ATTR1
, PLL.ATTRIBUTE1 UA_LINE_ATTR2
, PLL.ATTRIBUTE1 UA_LINE_ATTR3
, PLL.ATTRIBUTE1 UA_LINE_ATTR4
, PLL.ATTRIBUTE1 UA_LINE_ATTR5
, PLL.ATTRIBUTE1 UA_LINE_ATTR6
, PLL.ATTRIBUTE1 UA_LINE_ATTR7
, PLL.ATTRIBUTE1 UA_LINE_ATTR8
, PLL.ATTRIBUTE1 UA_LINE_ATTR9
, PLL.ATTRIBUTE1 UA_LINE_ATTR10
, PLL.ATTRIBUTE1 UA_LINE_ATTR11
, PLL.ATTRIBUTE1 UA_LINE_ATTR12
, PLL.ATTRIBUTE1 UA_LINE_ATTR13
, PLL.ATTRIBUTE1 UA_LINE_ATTR14
, PLL.ATTRIBUTE1 UA_LINE_ATTR15
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'PO INTERNAL'
, PLA.PO_LINE_ID) TO_PO_INTERNAL
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'MISC'
, PLA.PO_LINE_ID) TO_MISC
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATTIONS'
, 'APPROVER'
, PLA.PO_LINE_ID) TO_APPROVER
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'BUYER'
, PLA.PO_LINE_ID) TO_BUYER
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'PAYABLES'
, PLA.PO_LINE_ID) TO_PAYABLES
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'RECEIVER'
, PLA.PO_LINE_ID) TO_RECEIVER
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'VENDOR'
, PLA.PO_LINE_ID) TO_SUPPLIER
FROM MTL_CATEGORIES CAT
, MTL_UNITS_OF_MEASURE UOM
, MTL_SYSTEM_ITEMS MI
, PO_LINES_ALL PLA
, PO_HAZARD_CLASSES_TL HAZTL
, PO_HEADERS_ALL PHA
, PO_LINE_LOCATIONS_ALL PLL
, PO_RELEASES_ALL R
WHERE UOM.UNIT_OF_MEASURE (+) = PLA.UNIT_MEAS_LOOKUP_CODE
AND CAT.CATEGORY_ID (+) = PLA.CATEGORY_ID
AND PHA.PO_HEADER_ID = PLA.PO_HEADER_ID
AND MI.INVENTORY_ITEM_ID (+) = PLA.ITEM_ID
AND HAZTL.HAZARD_CLASS_ID (+) = PLA.HAZARD_CLASS_ID
AND PLA.PO_LINE_ID = PLL.PO_LINE_ID
AND R.PO_RELEASE_ID = PLL.PO_RELEASE_ID
AND MI.ORGANIZATION_ID (+) = ITG_X_UTILS.GET_INVENTORY_ORG_ID(PLA.ORG_ID)
AND HAZTL.HAZARD_CLASS_ID (+) = USERENV('LANG')

Columns