FND Design Data [Home] [Help]

View: PO_ECX_LINE_V

Product: PO - Purchasing
Description:
Implementation/DBA Data: ViewAPPS.PO_ECX_LINE_V
View Text

SELECT PLA.PO_HEADER_ID PO_HEADER_ID
, PLA.LINE_NUM LINE_NUM
, PLLA.PO_RELEASE_ID RELEASE_ID
, PLA.QUANTITY QUANTITY
, PLA.UNIT_MEAS_LOOKUP_CODE QUANT_UOM
, PLA.VENDOR_PRODUCT_NUM ITEMX
, MSIV.SEGMENT1 ITEM
, PLA.ITEM_DESCRIPTION DESCRIPTION
, PHC.HAZARD_CLASS HAZRDMTL
, PLA.ITEM_REVISION ITEMRVX
, PLA.NOTE_TO_VENDOR
, PLA.UNIT_PRICE PRICE
, 'UNIT' UNIT
, PLA.CATEGORY_ID CATEGORYID
, PLA.CONTRACT_NUM CONTRACT
, PLA.TASK_ID TASKID
, PLA.PROJECT_ID PROJECTID
FROM PO_DISTINCT_RELID_LINEID_V PLLA
, PO_LINES_ARCHIVE_ALL PLA
, PO_HEADERS_ALL PHA
, MTL_SYSTEM_ITEMS_B_KFV MSIV
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, PO_HAZARD_CLASSES PHC
WHERE NVL(MSIV.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
AND FSP.ORG_ID = PLA.ORG_ID
AND MSIV.INVENTORY_ITEM_ID (+) = PLA.ITEM_ID
AND PLA.PO_LINE_ID = PLLA.PO_LINE_ID
AND PLA.REVISION_NUM = 0
AND (PLA.CANCEL_FLAG != 'Y' OR PLA.CANCEL_FLAG IS NULL)
AND (PLA.CLOSED_CODE = 'OPEN' OR PLA.CLOSED_CODE IS NULL)
AND PHA.PO_HEADER_ID = PLA.PO_HEADER_ID
AND (PHA.TYPE_LOOKUP_CODE = 'BLANKET' OR PHA.TYPE_LOOKUP_CODE = 'PLANNED')
AND PLA.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+) UNION ALL SELECT PLA.PO_HEADER_ID PO_HEADER_ID
, PLA.LINE_NUM LINE_NUM
, 0 RELEASE_ID
, PLA.QUANTITY QUANTITY
, PLA.UNIT_MEAS_LOOKUP_CODE QUANT_UOM
, PLA.VENDOR_PRODUCT_NUM ITEMX
, MSIV.SEGMENT1 ITEM
, PLA.ITEM_DESCRIPTION DESCRIPTION
, PHC.HAZARD_CLASS HAZRDMTL
, PLA.ITEM_REVISION ITEMRVX
, PLA.NOTE_TO_VENDOR
, PLA.UNIT_PRICE PRICE
, 'UNIT' UNIT
, PLA.CATEGORY_ID CATEGORYID
, PLA.CONTRACT_NUM CONTRACT
, PLA.TASK_ID TASKID
, PLA.PROJECT_ID PROJECTID
FROM PO_HEADERS_ALL PHA
, PO_LINES_ARCHIVE_ALL PLA
, MTL_SYSTEM_ITEMS_B_KFV MSIV
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, PO_HAZARD_CLASSES PHC
WHERE NVL(MSIV.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
AND FSP.ORG_ID = PLA.ORG_ID
AND MSIV.INVENTORY_ITEM_ID (+) = PLA.ITEM_ID
AND PLA.PO_HEADER_ID = PHA.PO_HEADER_ID
AND PLA.REVISION_NUM = 0
AND (PLA.CANCEL_FLAG != 'Y' OR PLA.CANCEL_FLAG IS NULL)
AND (PLA.CLOSED_CODE = 'OPEN' OR PLA.CLOSED_CODE IS NULL)
AND PHA.TYPE_LOOKUP_CODE = 'STANDARD'
AND PLA.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+)

Columns

Name
PO_HEADER_ID
LINE_NUM
RELEASE_ID
QUANTITY
QUANT_UOM
ITEMX
ITEM
DESCRIPTION
HAZRDMTL
ITEMRVX
NOTE_TO_VENDOR
PRICE
UNIT
CATEGORYID
CONTRACT
TASKID
PROJECTID