VIEW: APPS.PO_LINES_RFQQT_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 , POL.ITEM_REVISION , POL.CATEGORY_ID , POL.ITEM_DESCRIPTION , POL.UNIT_MEAS_LOOKUP_CODE , MUOM.UOM_CLASS , 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 , POL.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 ,POL.PROJECT_ID ,pjm_project.ALL_PROJ_IDTONUM(POL.PROJECT_ID) ,POL.TASK_ID ,pjm_project.ALL_TASK_IDTONUM(POL.TASK_ID) ,POL.QC_GRADE ,POL.BASE_UOM ,POL.BASE_QTY ,POL.SECONDARY_UOM ,POL.SECONDARY_QTY ,POL.OKE_CONTRACT_HEADER_ID ,POL.OKE_CONTRACT_VERSION_ID ,PLT.PURCHASE_BASIS ,PLT.MATCHING_BASIS ,POL.ORG_ID FROM PO_LINES POL , PO_LINE_TYPES PLT , MTL_UNITS_OF_MEASURE MUOM, PO_UN_NUMBERS_TL PUN , PO_HAZARD_CLASSES_TL PHC , MTL_SYSTEM_ITEMS MSI , FINANCIALS_SYSTEM_PARAMS_ALL FSP WHERE PLT.LINE_TYPE_ID (+) = POL.LINE_TYPE_ID AND PUN.UN_NUMBER_ID (+) = POL.UN_NUMBER_ID AND PUN.LANGUAGE(+) = USERENV('LANG') AND PHC.HAZARD_CLASS_ID (+) = POL.HAZARD_CLASS_ID AND PHC.LANGUAGE(+) = USERENV('LANG') 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 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
, POL.ITEM_REVISION
, POL.CATEGORY_ID
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, MUOM.UOM_CLASS
, 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
, POL.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
, POL.PROJECT_ID
, PJM_PROJECT.ALL_PROJ_IDTONUM(POL.PROJECT_ID)
, POL.TASK_ID
, PJM_PROJECT.ALL_TASK_IDTONUM(POL.TASK_ID)
, POL.QC_GRADE
, POL.BASE_UOM
, POL.BASE_QTY
, POL.SECONDARY_UOM
, POL.SECONDARY_QTY
, POL.OKE_CONTRACT_HEADER_ID
, POL.OKE_CONTRACT_VERSION_ID
, PLT.PURCHASE_BASIS
, PLT.MATCHING_BASIS
, POL.ORG_ID
FROM PO_LINES POL
, PO_LINE_TYPES PLT
, MTL_UNITS_OF_MEASURE MUOM
, PO_UN_NUMBERS_TL PUN
, PO_HAZARD_CLASSES_TL PHC
, MTL_SYSTEM_ITEMS MSI
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
WHERE PLT.LINE_TYPE_ID (+) = POL.LINE_TYPE_ID
AND PUN.UN_NUMBER_ID (+) = POL.UN_NUMBER_ID
AND PUN.LANGUAGE(+) = USERENV('LANG')
AND PHC.HAZARD_CLASS_ID (+) = POL.HAZARD_CLASS_ID
AND PHC.LANGUAGE(+) = USERENV('LANG')
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 FSP.ORG_ID = POL.ORG_ID