View: QA_SKIPLOT_RCV_RESULTS_V

Product:	QA - Quality
Description:	Skip Lot results for Receiving
Implementation/DBA Data:	APPS.QA_SKIPLOT_RCV_RESULTS_V

View Text

SELECT QSRR.INSP_LOT_ID
, QSRR.CRITERIA_ID
, QSRR.PROCESS_ID
, QSP.PROCESS_CODE
, RSL.TO_ORGANIZATION_ID ORGANIZATION_ID
, QSRR.RECEIPT_DATE
, QSRR.SOURCE_INSPECTED
, QL1.MEANING INSPECTION_STATUS
, QSRR.LOT_QTY
, QSRR.TRANSACTED_QTY
, QL2.MEANING INSPECTION_RESULT
, QSRR.LAST_INSP_DATE
, QSRR.SHIPMENT_LINE_ID
, RSL.LINE_NUM SHIPMENT_LINE_NUM
, RSL.SHIPMENT_HEADER_ID
, RSH.SHIPMENT_NUM
, RSH.RECEIPT_NUM
, RSL.VENDOR_ITEM_NUM
, RSL.VENDOR_LOT_NUM
, MSIK.CONCATENATED_SEGMENTS ITEM
, RSL.ITEM_ID
, RSL.ITEM_DESCRIPTION
, RSL.ITEM_REVISION
, RSL.CATEGORY_ID
, MCK.CONCATENATED_SEGMENTS CATEGORY_DESC
, RSL.PO_HEADER_ID
, PH.SEGMENT1 PO_NUMBER
, PH.VENDOR_ID
, PH.VENDOR_SITE_ID
, HP.PARTY_NAME VENDOR_NAME
, PVS.VENDOR_SITE_CODE
, RSL.PO_LINE_ID
, PL.LINE_NUM PO_LINE_NUMBER
, RSL.OE_ORDER_HEADER_ID
, QA_FLEX_UTIL.SALES_ORDER (RSL.OE_ORDER_HEADER_ID) SALES_ORDER
, QSRR.MANUFACTURER_ID
, MM.MANUFACTURER_NAME
, PD.PROJECT_ID
, QA_FLEX_UTIL.PROJECT_NUMBER(PD.PROJECT_ID) PROJECT_NUMBER
, PD.TASK_ID
, PT.TASK_NUMBER
, QSRR.LPN_ID
, WLPN.LICENSE_PLATE_NUMBER LPN
, QSRR.LAST_UPDATE_DATE
, QSRR.LAST_UPDATED_BY
, QSRR.CREATION_DATE
, QSRR.CREATED_BY
, QSRR.LAST_UPDATE_LOGIN
FROM QA_SKIPLOT_RCV_RESULTS QSRR
, QA_LOOKUPS QL1
, QA_LOOKUPS QL2
, RCV_SHIPMENT_LINES RSL
, RCV_SHIPMENT_HEADERS RSH
, MTL_CATEGORIES_KFV MCK
, MTL_MANUFACTURERS MM
, PO_HEADERS_ALL PH
, PO_LINES_ALL PL
, PO_DISTRIBUTIONS_ALL PD
, PA_TASKS PT
, AP_SUPPLIERS PV
, HZ_PARTIES HP
, AP_SUPPLIER_SITES_ALL PVS
, QA_SKIPLOT_PROCESSES QSP
, MTL_SYSTEM_ITEMS_KFV MSIK
, WMS_LICENSE_PLATE_NUMBERS WLPN
WHERE QSRR.PROCESS_ID = QSP.PROCESS_ID (+)
AND QSRR.INSPECTION_STATUS = QL1.LOOKUP_CODE (+)
AND QL1.LOOKUP_TYPE (+) = 'QA_SKIPLOT_STATUS'
AND QSRR.INSPECTION_RESULT = QL2.LOOKUP_CODE (+)
AND QL2.LOOKUP_TYPE (+) = 'QA_SKIPLOT_RESULT'
AND QSRR.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID (+)
AND RSL.ITEM_ID = MSIK.INVENTORY_ITEM_ID (+)
AND RSL.TO_ORGANIZATION_ID = MSIK.ORGANIZATION_ID (+)
AND RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID (+)
AND RSL.CATEGORY_ID = MCK.CATEGORY_ID (+)
AND RSL.PO_HEADER_ID = PH.PO_HEADER_ID (+)
AND RSL.PO_LINE_ID = PL.PO_LINE_ID (+)
AND RSL.PO_DISTRIBUTION_ID = PD.PO_DISTRIBUTION_ID (+)
AND QSRR.MANUFACTURER_ID = MM.MANUFACTURER_ID (+)
AND PD.TASK_ID = PT.TASK_ID (+)
AND PH.VENDOR_ID = PV.VENDOR_ID (+)
AND PV.PARTY_ID = HP.PARTY_ID (+)
AND PH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID (+)
AND QSRR.VALID_FLAG NOT IN (1
, 3)
AND QSRR.LPN_ID = WLPN.LPN_ID (+)

Columns