VIEW: APPS.ICX_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 , ICX_UTIL.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 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 pll, hr_locations 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

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
, ICX_UTIL.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 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 PLL
, HR_LOCATIONS 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