VIEW: APPS.POS_PO_RFQ_LINES_V

Source

View Text - Preformatted

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, NVL(PLL.PRICE_OVERRIDE, POL.UNIT_PRICE), 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, PLL.LINE_LOCATION_ID, PLL.SHIP_TO_LOCATION_ID ,FSP.INVENTORY_ORGANIZATION_ID 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_PARAMS_ALL 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 NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_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 AND POL.ORG_ID = NVL(FSP.ORG_ID, POL.ORG_ID)

View Text - HTML Formatted

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
, NVL(PLL.PRICE_OVERRIDE
, POL.UNIT_PRICE)
, 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
, PLL.LINE_LOCATION_ID
, PLL.SHIP_TO_LOCATION_ID
, FSP.INVENTORY_ORGANIZATION_ID
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_PARAMS_ALL 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 NVL(MSI.ORGANIZATION_ID
, FSP.INVENTORY_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
AND POL.ORG_ID = NVL(FSP.ORG_ID
, POL.ORG_ID)