View: RCV_ENTER_RECEIPTS_INT_REQ_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.RCV_ENTER_RECEIPTS_INT_REQ_V

View Text

SELECT 'N'
, 'INTERNAL'
, DECODE(RSL.SOURCE_DOCUMENT_CODE
, 'REQ'
, 'INTERNAL ORDER')
, RSL.SOURCE_DOCUMENT_CODE
, RSH.RECEIPT_SOURCE_CODE
, TO_NUMBER( NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER( NULL)
, TO_NUMBER( NULL)
, TO_NUMBER( NULL)
, TO_NUMBER( NULL)
, TO_NUMBER( NULL)
, PORH.REQUISITION_HEADER_ID
, PORH.SEGMENT1
, PORL.REQUISITION_LINE_ID
, PORL.LINE_NUM
, RSL.REQ_DISTRIBUTION_ID
, RSL.SHIPMENT_HEADER_ID
, RSH.SHIPMENT_NUM
, RSL.SHIPMENT_LINE_ID
, RSL.LINE_NUM
, RSL.FROM_ORGANIZATION_ID
, RSL.TO_ORGANIZATION_ID
, RSL.SHIPMENT_LINE_ID
, OOD.ORGANIZATION_NAME
, TO_NUMBER(NULL)
, 'N'
, RSL.ITEM_ID
, RSL.UNIT_OF_MEASURE
, MUM.UOM_CLASS
, NVL(MSI.ALLOWED_UNITS_LOOKUP_CODE
, 2)
, NVL(MSI.LOCATION_CONTROL_CODE
, 1)
, DECODE(MSI.RESTRICT_LOCATORS_CODE
, 1
, 'Y'
, 'N')
, DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE
, 1
, 'Y'
, 'N')
, NVL(MSI.SHELF_LIFE_CODE
, 1)
, NVL(MSI.SHELF_LIFE_DAYS
, 0)
, MSI.SERIAL_NUMBER_CONTROL_CODE
, MSI.LOT_CONTROL_CODE
, DECODE(MSI.REVISION_QTY_CONTROL_CODE
, 1
, 'N'
, 2
, 'Y'
, 'N')
, DECODE(MSI1.REVISION_QTY_CONTROL_CODE
, 1
, 'N'
, 2
, 'Y'
, 'N')
, NULL ITEM_NUMBER
, RSL.ITEM_REVISION
, RSL.ITEM_DESCRIPTION
, RSL.CATEGORY_ID
, POHC.HAZARD_CLASS
, POUN.UN_NUMBER
, RSL.VENDOR_ITEM_NUM
, RSH.SHIP_TO_LOCATION_ID
, HL.LOCATION_CODE
, RSH.PACKING_SLIP
, RSL.ROUTING_HEADER_ID
, RCVRH.ROUTING_NAME
, PORL.NEED_BY_DATE
, RSH.EXPECTED_RECEIPT_DATE
, RSL.QUANTITY_SHIPPED
, RSL.UNIT_OF_MEASURE
, RSH.USSGL_TRANSACTION_CODE
, RSH.GOVERNMENT_CONTEXT
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, PORL.NOTE_TO_RECEIVER
, RSL.DESTINATION_TYPE_CODE
, RSL.DELIVER_TO_PERSON_ID
, RSL.DELIVER_TO_LOCATION_ID
, RSL.TO_SUBINVENTORY
, RSL.ATTRIBUTE_CATEGORY
, RSL.ATTRIBUTE1
, RSL.ATTRIBUTE2
, RSL.ATTRIBUTE3
, RSL.ATTRIBUTE4
, RSL.ATTRIBUTE5
, RSL.ATTRIBUTE6
, RSL.ATTRIBUTE7
, RSL.ATTRIBUTE8
, RSL.ATTRIBUTE9
, RSL.ATTRIBUTE10
, RSL.ATTRIBUTE11
, RSL.ATTRIBUTE12
, RSL.ATTRIBUTE13
, RSL.ATTRIBUTE14
, RSL.ATTRIBUTE15
, 'OPEN'
, NULL
, RSH.BILL_OF_LADING
, RSH.SHIPPED_DATE
, RSH.FREIGHT_CARRIER_CODE
, RSH.WAYBILL_AIRBILL_NUM
, RSH.FREIGHT_BILL_NUMBER
, RSL.VENDOR_LOT_NUM
, RSL.CONTAINER_NUM
, RSL.TRUCK_NUM
, RSL.BAR_CODE_LABEL
, NULL
, 'P'
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, PORL.NOTE_TO_RECEIVER PLL_NOTE_TO_RECEIVER
, RSL.SECONDARY_QUANTITY_SHIPPED SECONDARY_ORDERED_QTY
, RSL.SECONDARY_UNIT_OF_MEASURE SECONDARY_ORDERED_UOM
, RSL.QC_GRADE QC_GRADE
, TO_NUMBER(NULL)
, DECODE(MSI.TRACKING_QUANTITY_IND
, 'PS'
, MSI.SECONDARY_DEFAULT_IND
, NULL)
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, MTL_SUPPLY MS
, PO_REQUISITION_HEADERS PORH
, PO_REQUISITION_LINES PORL
, PO_HAZARD_CLASSES_TL POHC
, PO_UN_NUMBERS_TL POUN
, RCV_ROUTING_HEADERS RCVRH
, HR_LOCATIONS_ALL_TL HL
, MTL_SYSTEM_ITEMS MSI
, MTL_SYSTEM_ITEMS MSI1
, MTL_UNITS_OF_MEASURE MUM
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE RSH.RECEIPT_SOURCE_CODE = 'INTERNAL ORDER'
AND RSL.REQUISITION_LINE_ID = PORL.REQUISITION_LINE_ID
AND PORL.REQUISITION_HEADER_ID = PORH.REQUISITION_HEADER_ID
AND MS.SUPPLY_TYPE_CODE = 'SHIPMENT'
AND MS.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND RSH.SHIP_TO_LOCATION_ID = HL.LOCATION_ID (+)
AND HL.LANGUAGE(+) = USERENV('LANG')
AND PORL.HAZARD_CLASS_ID = POHC.HAZARD_CLASS_ID (+)
AND POHC.LANGUAGE(+) = USERENV('LANG')
AND PORL.UN_NUMBER_ID = POUN.UN_NUMBER_ID (+)
AND POUN.LANGUAGE(+) = USERENV('LANG')
AND RSL.ROUTING_HEADER_ID = RCVRH.ROUTING_HEADER_ID(+)
AND MUM.UNIT_OF_MEASURE (+) = RSL.UNIT_OF_MEASURE
AND MSI.ORGANIZATION_ID (+) = RSL.TO_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID (+) = RSL.ITEM_ID
AND MSI1.ORGANIZATION_ID (+) = RSL.FROM_ORGANIZATION_ID
AND MSI1.INVENTORY_ITEM_ID (+) = RSL.ITEM_ID
AND OOD.ORGANIZATION_ID = RSL.FROM_ORGANIZATION_ID
AND MS.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID

Columns