VIEW: APPS.QA_SKIPLOT_RCV_RESULTS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)