VIEW: APPS.POR_CONFIRM_INTERNAL_RECEIPT_V

Source

View Text - Preformatted

SELECT SYSDATE RECEIPT_DATE, PORL.TO_PERSON_ID REQUESTOR_ID, OSH.HEADER_ID PO_HEADER_ID, NULL, TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), PORL.DESTINATION_ORGANIZATION_ID TO_ORGANIZATION_ID, PORL.ITEM_ID ITEM_ID, PORL.UNIT_MEAS_LOOKUP_CODE PRIMARY_UOM, MUM.UOM_CLASS UOM_CLASS, PORL.QUANTITY_DELIVERED, PORL.QUANTITY - NVL(PORL.QUANTITY_CANCELLED, 0) - NVL(PORL.QUANTITY_DELIVERED, 0) EXPECTED_RECEIPT_QTY, PORL.ITEM_DESCRIPTION, PORL.DELIVER_TO_LOCATION_ID SHIP_TO_LOCATION_ID, TO_NUMBER(NULL), OOD.NAME, TO_NUMBER(NULL), NULL, PORL.NEED_BY_DATE NEED_BY_DATE, TO_DATE(NULL), PORL.NEED_BY_DATE EXPECTED_RECEIPT_DATE, PORL.QUANTITY ORDERED_QTY, PORL.UNIT_MEAS_LOOKUP_CODE ORDERED_UOM, PORL.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, TO_NUMBER(NULL), PORL.DELIVER_TO_LOCATION_ID, TO_NUMBER(NULL), TO_NUMBER(NULL), NULL, TO_CHAR(OSH.ORDER_NUMBER) PO_NUM_REL_NUM, OSH.ORDER_NUMBER, PORL.REQUISITION_LINE_ID, POR_RCV_TRANSACTION_SV.GET_SHIPMENT_NUM('REQ', PORL.REQUISITION_LINE_ID), 'REQ', OSH.HEADER_ID SO_HEADER_ID, OSL.LINE_NUMBER, PORL.REQUISITION_HEADER_ID, PORL.REQUISITION_LINE_ID, PORL.DESTINATION_TYPE_CODE, 'Y' RECEIPT_REQUIRED_FLAG, RSH.WAYBILL_AIRBILL_NUM, RSL.PACKING_SLIP, RSL.COMMENTS, PORH.CREATION_DATE, PORH.SEGMENT1, NVL(PORL.CURRENCY_CODE, PO_CORE_S2.GET_BASE_CURRENCY), PORL.UNIT_PRICE FROM PO_REQUISITION_LINES PORL, PO_REQUISITION_HEADERS PORH, OE_ORDER_HEADERS OSH, OE_ORDER_LINES OSL, MTL_UNITS_OF_MEASURE MUM, HR_ALL_ORGANIZATION_UNITS_TL OOD, RCV_SHIPMENT_HEADERS RSH, RCV_SHIPMENT_LINES RSL, PO_SYSTEM_PARAMETERS POSP WHERE PORL.QUANTITY - NVL(PORL.QUANTITY_CANCELLED, 0) - NVL(PORL.QUANTITY_DELIVERED, 0) > 0 AND PORL.SOURCE_TYPE_CODE = 'INVENTORY' AND OSH.ORDER_SOURCE_ID = POSP.ORDER_SOURCE_ID AND OSH.ORIG_SYS_DOCUMENT_REF = PORH.SEGMENT1 AND OSH.HEADER_ID = OSL.HEADER_ID AND OSL.ORIG_SYS_LINE_REF = TO_CHAR(PORL.LINE_NUM) AND MUM.UNIT_OF_MEASURE (+) = PORL.UNIT_MEAS_LOOKUP_CODE AND OOD.ORGANIZATION_ID = PORL.SOURCE_ORGANIZATION_ID AND OOD.LANGUAGE(+) = USERENV('LANG') AND PORL.REQUISITION_LINE_ID = RSL.REQUISITION_LINE_ID AND RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID AND RSH.ASN_TYPE IS NULL AND PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID AND RSL.ROUTING_HEADER_ID = 3

View Text - HTML Formatted

SELECT SYSDATE RECEIPT_DATE
, PORL.TO_PERSON_ID REQUESTOR_ID
, OSH.HEADER_ID PO_HEADER_ID
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PORL.DESTINATION_ORGANIZATION_ID TO_ORGANIZATION_ID
, PORL.ITEM_ID ITEM_ID
, PORL.UNIT_MEAS_LOOKUP_CODE PRIMARY_UOM
, MUM.UOM_CLASS UOM_CLASS
, PORL.QUANTITY_DELIVERED
, PORL.QUANTITY - NVL(PORL.QUANTITY_CANCELLED
, 0) - NVL(PORL.QUANTITY_DELIVERED
, 0) EXPECTED_RECEIPT_QTY
, PORL.ITEM_DESCRIPTION
, PORL.DELIVER_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, TO_NUMBER(NULL)
, OOD.NAME
, TO_NUMBER(NULL)
, NULL
, PORL.NEED_BY_DATE NEED_BY_DATE
, TO_DATE(NULL)
, PORL.NEED_BY_DATE EXPECTED_RECEIPT_DATE
, PORL.QUANTITY ORDERED_QTY
, PORL.UNIT_MEAS_LOOKUP_CODE ORDERED_UOM
, PORL.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, TO_NUMBER(NULL)
, PORL.DELIVER_TO_LOCATION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_CHAR(OSH.ORDER_NUMBER) PO_NUM_REL_NUM
, OSH.ORDER_NUMBER
, PORL.REQUISITION_LINE_ID
, POR_RCV_TRANSACTION_SV.GET_SHIPMENT_NUM('REQ'
, PORL.REQUISITION_LINE_ID)
, 'REQ'
, OSH.HEADER_ID SO_HEADER_ID
, OSL.LINE_NUMBER
, PORL.REQUISITION_HEADER_ID
, PORL.REQUISITION_LINE_ID
, PORL.DESTINATION_TYPE_CODE
, 'Y' RECEIPT_REQUIRED_FLAG
, RSH.WAYBILL_AIRBILL_NUM
, RSL.PACKING_SLIP
, RSL.COMMENTS
, PORH.CREATION_DATE
, PORH.SEGMENT1
, NVL(PORL.CURRENCY_CODE
, PO_CORE_S2.GET_BASE_CURRENCY)
, PORL.UNIT_PRICE
FROM PO_REQUISITION_LINES PORL
, PO_REQUISITION_HEADERS PORH
, OE_ORDER_HEADERS OSH
, OE_ORDER_LINES OSL
, MTL_UNITS_OF_MEASURE MUM
, HR_ALL_ORGANIZATION_UNITS_TL OOD
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_SYSTEM_PARAMETERS POSP
WHERE PORL.QUANTITY - NVL(PORL.QUANTITY_CANCELLED
, 0) - NVL(PORL.QUANTITY_DELIVERED
, 0) > 0
AND PORL.SOURCE_TYPE_CODE = 'INVENTORY'
AND OSH.ORDER_SOURCE_ID = POSP.ORDER_SOURCE_ID
AND OSH.ORIG_SYS_DOCUMENT_REF = PORH.SEGMENT1
AND OSH.HEADER_ID = OSL.HEADER_ID
AND OSL.ORIG_SYS_LINE_REF = TO_CHAR(PORL.LINE_NUM)
AND MUM.UNIT_OF_MEASURE (+) = PORL.UNIT_MEAS_LOOKUP_CODE
AND OOD.ORGANIZATION_ID = PORL.SOURCE_ORGANIZATION_ID
AND OOD.LANGUAGE(+) = USERENV('LANG')
AND PORL.REQUISITION_LINE_ID = RSL.REQUISITION_LINE_ID
AND RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RSH.ASN_TYPE IS NULL
AND PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID
AND RSL.ROUTING_HEADER_ID = 3