View: POS_PO_RFQ_LINES_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_PO_RFQ_LINES_V

View Text

SELECT POL.ROWID
, POL.PO_HEADER_ID
, POL.PO_LINE_ID
, POL.LINE_NUM
, POL.LINE_TYPE_ID
, PLT.LINE_TYPE
, POL.ITEM_ID
, POS_GET.ITEM_FLEX_SEG( MSI.ROWID )
, POL.ITEM_REVISION
, POL.CATEGORY_ID
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, MUOM.UOM_CLASS
, PLL.PRICE_OVERRIDE
, POL.VENDOR_PRODUCT_NUM
, POL.UN_NUMBER_ID
, PUN.UN_NUMBER
, POL.HAZARD_CLASS_ID
, PHC.HAZARD_CLASS
, POL.MIN_ORDER_QUANTITY
, POL.MAX_ORDER_QUANTITY
, POL.NOTE_TO_VENDOR
, POL.FROM_HEADER_ID
, POL.FROM_LINE_ID
, POL.TAXABLE_FLAG
, PLL.QUANTITY
, MSI.ALLOW_ITEM_DESC_UPDATE_FLAG
, MSI.ALLOWED_UNITS_LOOKUP_CODE
, PLT.ORDER_TYPE_LOOKUP_CODE
, NVL(PLT.OUTSIDE_OPERATION_FLAG
, 'N')
, POL.LAST_UPDATE_DATE
, POL.LAST_UPDATED_BY
, POL.LAST_UPDATE_LOGIN
, POL.CREATED_BY
, POL.CREATION_DATE
, POL.PROGRAM_ID
, POL.PROGRAM_UPDATE_DATE
, POL.REQUEST_ID
, POL.PROGRAM_APPLICATION_ID
, POL.ATTRIBUTE1
, POL.ATTRIBUTE2
, POL.ATTRIBUTE3
, POL.ATTRIBUTE4
, POL.ATTRIBUTE5
, POL.ATTRIBUTE6
, POL.ATTRIBUTE7
, POL.ATTRIBUTE8
, POL.ATTRIBUTE9
, POL.ATTRIBUTE10
, POL.ATTRIBUTE11
, POL.ATTRIBUTE12
, POL.ATTRIBUTE13
, POL.ATTRIBUTE14
, POL.ATTRIBUTE15
, POL.ATTRIBUTE_CATEGORY
, PLL.SHIPMENT_NUM
, HRL.LOCATION_CODE
, PLL.SHIP_VIA_LOOKUP_CODE
, APT.DESCRIPTION
FROM PO_LINES_ALL POL
, PO_LINE_TYPES PLT
, MTL_UNITS_OF_MEASURE MUOM
, PO_UN_NUMBERS PUN
, PO_HAZARD_CLASSES PHC
, MTL_SYSTEM_ITEMS MSI
, FINANCIALS_SYSTEM_PARAMETERS FSP
, PO_LINE_LOCATIONS_ALL PLL
, HR_LOCATIONS_ALL HRL
, AP_TERMS APT
WHERE PLT.LINE_TYPE_ID(+)=POL.LINE_TYPE_ID
AND PUN.UN_NUMBER_ID(+)=POL.UN_NUMBER_ID
AND PHC.HAZARD_CLASS_ID(+)=POL.HAZARD_CLASS_ID
AND MUOM.UNIT_OF_MEASURE(+)=POL.UNIT_MEAS_LOOKUP_CODE
AND POL.ITEM_ID=MSI.INVENTORY_ITEM_ID(+)
AND PUN.UN_NUMBER_ID(+)=POL.UN_NUMBER_ID
AND PHC.HAZARD_CLASS_ID(+)=POL.HAZARD_CLASS_ID
AND NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)= FSP.INVENTORY_ORGANIZATION_ID
AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND FSP.INVENTORY_ORGANIZATION_ID = NVL( MSI.ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID )
AND POL.PO_LINE_ID = PLL.PO_LINE_ID (+)
AND HRL.LOCATION_ID (+) = PLL.SHIP_TO_LOCATION_ID
AND APT.TERM_ID (+) = PLL.TERMS_ID

Columns