VIEW: APPS.POS_PO_QA_SHIPMENTS_V

Source

View Text - Preformatted

SELECT poh.PO_HEADER_ID, decode(prl.PO_RELEASE_ID, NULL, poh.SEGMENT1, poh.SEGMENT1 || '-' || to_char(prl.RELEASE_NUM)), prl.PO_RELEASE_ID, pol.PO_LINE_ID, pol.LINE_NUM, poll.LINE_LOCATION_ID, poll.SHIPMENT_NUM, poll.SHIP_TO_LOCATION_ID, hrt.LOCATION_CODE, pol.VENDOR_PRODUCT_NUM, pol.ITEM_DESCRIPTION, poll.QUANTITY, nvl(poll.UNIT_MEAS_LOOKUP_CODE, pol.UNIT_MEAS_LOOKUP_CODE), nvl(poll.PROMISED_DATE, poll.NEED_BY_DATE), poh.VENDOR_ID, ven.VENDOR_NAME, poh.VENDOR_SITE_ID, vst.VENDOR_SITE_CODE, poll.SHIP_TO_ORGANIZATION_ID, MP.ORGANIZATION_CODE, sto.NAME ORGANIZATION_NAME, pol.ITEM_ID, msi.CONCATENATED_SEGMENTS, pol.ITEM_REVISION, pol.CATEGORY_ID, mct.CONCATENATED_SEGMENTS, poh.SEGMENT1, fnd_message.get_string('QA', 'QA_SS_AVAILABLE'), poh.org_id, hou.name FROM PO_HEADERS_ALL POH, PO_LINES_ALL POL, PO_RELEASES_ALL PRL, PO_LINE_LOCATIONS_ALL POLL, HR_LOCATIONS_ALL HRT, AP_SUPPLIERS VEN, HZ_PARTIES HP, AP_SUPPLIER_SITES_ALL VST, MTL_PARAMETERS MP, HR_ALL_ORGANIZATION_UNITS_TL STO, MTL_SYSTEM_ITEMS_KFV MSI, MTL_CATEGORIES_KFV MCT, HR_ALL_ORGANIZATION_UNITS_TL HOU WHERE POLL.PO_HEADER_ID = POH.PO_HEADER_ID AND POLL.PO_LINE_ID = POL.PO_LINE_ID AND POLL.PO_RELEASE_ID = PRL.PO_RELEASE_ID(+) AND POLL.SHIP_TO_LOCATION_ID = HRT.LOCATION_ID AND POH.VENDOR_ID = VEN.VENDOR_ID AND POH.VENDOR_SITE_ID = VST.VENDOR_SITE_ID AND POH.ORG_ID = VST.ORG_ID AND POLL.SHIP_TO_ORGANIZATION_ID = STO.ORGANIZATION_ID AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND NVL(MSI.ORGANIZATION_ID, POLL.SHIP_TO_ORGANIZATION_ID) = POLL.SHIP_TO_ORGANIZATION_ID AND POL.CATEGORY_ID = MCT.CATEGORY_ID AND NVL(POLL.APPROVED_FLAG,'N') = 'Y' AND NVL(POLL.CANCEL_FLAG, 'N') = 'N' AND NVL(POLL.CLOSED_CODE,'OPEN') != 'FINALLY CLOSED' AND POLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED') AND HP.PARTY_ID = VEN.PARTY_ID AND MP.ORGANIZATION_ID = STO.ORGANIZATION_ID AND STO.LANGUAGE (+) = USERENV('LANG') AND QA_SS_SHIP.ARE_SHIP_PLANS_APPLICABLE ( POH.SEGMENT1, POL.LINE_NUM, PRL.RELEASE_NUM, POLL.SHIPMENT_NUM, HRT.LOCATION_CODE, POL.VENDOR_PRODUCT_NUM, POLL.QUANTITY, NVL(POLL.UNIT_MEAS_LOOKUP_CODE, POL.UNIT_MEAS_LOOKUP_CODE), VEN.VENDOR_NAME, VST.VENDOR_SITE_CODE, STO.NAME, MSI.CONCATENATED_SEGMENTS, POL.ITEM_REVISION, MCT.CONCATENATED_SEGMENTS) = 'Y' AND HOU.ORGANIZATION_ID (+) = POH.ORG_ID AND HOU.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT POH.PO_HEADER_ID
, DECODE(PRL.PO_RELEASE_ID
, NULL
, POH.SEGMENT1
, POH.SEGMENT1 || '-' || TO_CHAR(PRL.RELEASE_NUM))
, PRL.PO_RELEASE_ID
, POL.PO_LINE_ID
, POL.LINE_NUM
, POLL.LINE_LOCATION_ID
, POLL.SHIPMENT_NUM
, POLL.SHIP_TO_LOCATION_ID
, HRT.LOCATION_CODE
, POL.VENDOR_PRODUCT_NUM
, POL.ITEM_DESCRIPTION
, POLL.QUANTITY
, NVL(POLL.UNIT_MEAS_LOOKUP_CODE
, POL.UNIT_MEAS_LOOKUP_CODE)
, NVL(POLL.PROMISED_DATE
, POLL.NEED_BY_DATE)
, POH.VENDOR_ID
, VEN.VENDOR_NAME
, POH.VENDOR_SITE_ID
, VST.VENDOR_SITE_CODE
, POLL.SHIP_TO_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, STO.NAME ORGANIZATION_NAME
, POL.ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, POL.ITEM_REVISION
, POL.CATEGORY_ID
, MCT.CONCATENATED_SEGMENTS
, POH.SEGMENT1
, FND_MESSAGE.GET_STRING('QA'
, 'QA_SS_AVAILABLE')
, POH.ORG_ID
, HOU.NAME
FROM PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_RELEASES_ALL PRL
, PO_LINE_LOCATIONS_ALL POLL
, HR_LOCATIONS_ALL HRT
, AP_SUPPLIERS VEN
, HZ_PARTIES HP
, AP_SUPPLIER_SITES_ALL VST
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL STO
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_CATEGORIES_KFV MCT
, HR_ALL_ORGANIZATION_UNITS_TL HOU
WHERE POLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POLL.PO_LINE_ID = POL.PO_LINE_ID
AND POLL.PO_RELEASE_ID = PRL.PO_RELEASE_ID(+)
AND POLL.SHIP_TO_LOCATION_ID = HRT.LOCATION_ID
AND POH.VENDOR_ID = VEN.VENDOR_ID
AND POH.VENDOR_SITE_ID = VST.VENDOR_SITE_ID
AND POH.ORG_ID = VST.ORG_ID
AND POLL.SHIP_TO_ORGANIZATION_ID = STO.ORGANIZATION_ID
AND POL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND NVL(MSI.ORGANIZATION_ID
, POLL.SHIP_TO_ORGANIZATION_ID) = POLL.SHIP_TO_ORGANIZATION_ID
AND POL.CATEGORY_ID = MCT.CATEGORY_ID
AND NVL(POLL.APPROVED_FLAG
, 'N') = 'Y'
AND NVL(POLL.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POLL.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND POLL.SHIPMENT_TYPE IN ('STANDARD'
, 'BLANKET'
, 'SCHEDULED')
AND HP.PARTY_ID = VEN.PARTY_ID
AND MP.ORGANIZATION_ID = STO.ORGANIZATION_ID
AND STO.LANGUAGE (+) = USERENV('LANG')
AND QA_SS_SHIP.ARE_SHIP_PLANS_APPLICABLE ( POH.SEGMENT1
, POL.LINE_NUM
, PRL.RELEASE_NUM
, POLL.SHIPMENT_NUM
, HRT.LOCATION_CODE
, POL.VENDOR_PRODUCT_NUM
, POLL.QUANTITY
, NVL(POLL.UNIT_MEAS_LOOKUP_CODE
, POL.UNIT_MEAS_LOOKUP_CODE)
, VEN.VENDOR_NAME
, VST.VENDOR_SITE_CODE
, STO.NAME
, MSI.CONCATENATED_SEGMENTS
, POL.ITEM_REVISION
, MCT.CONCATENATED_SEGMENTS) = 'Y'
AND HOU.ORGANIZATION_ID (+) = POH.ORG_ID
AND HOU.LANGUAGE (+) = USERENV('LANG')