View: RCV_ENTER_RECEIPTS_PO_V

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

View Text

SELECT 'N'
, 'VENDOR'
, 'VENDOR'
, 'PO'
, POH.TYPE_LOOKUP_CODE
, POLL.PO_HEADER_ID
, POH.SEGMENT1
, POLL.PO_LINE_ID
, POL.LINE_NUM
, POLL.LINE_LOCATION_ID
, POLL.SHIPMENT_NUM
, POLL.PO_RELEASE_ID
, POR.RELEASE_NUM
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER( NULL)
, NULL
, TO_NUMBER( NULL)
, TO_NUMBER( NULL)
, POH.PO_HEADER_ID
, POLL.SHIP_TO_ORGANIZATION_ID
, POH.VENDOR_ID
, POV.VENDOR_NAME
, POH.VENDOR_SITE_ID
, NVL(POLT.OUTSIDE_OPERATION_FLAG
, 'N')
, POL.ITEM_ID
, POL.UNIT_MEAS_LOOKUP_CODE
, 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')
, NULL
, NULL ITEM_NUMBER
, POL.ITEM_REVISION
, POL.ITEM_DESCRIPTION
, POL.CATEGORY_ID
, POHC.HAZARD_CLASS
, POUN.UN_NUMBER
, POL.VENDOR_PRODUCT_NUM
, POLL.SHIP_TO_LOCATION_ID
, HL.LOCATION_CODE
, NULL
, POLL.RECEIVING_ROUTING_ID
, RCVRH.ROUTING_NAME
, POLL.NEED_BY_DATE
, NVL(POLL.PROMISED_DATE
, POLL.NEED_BY_DATE)
, POLL.QUANTITY
, POL.UNIT_MEAS_LOOKUP_CODE
, NULL
, POLL.GOVERNMENT_CONTEXT
, POLL.INSPECTION_REQUIRED_FLAG
, POLL.RECEIPT_REQUIRED_FLAG
, POLL.ENFORCE_SHIP_TO_LOCATION_CODE
, NVL(POLL.PRICE_OVERRIDE
, POL.UNIT_PRICE)
, POH.CURRENCY_CODE
, POH.RATE_TYPE
, POH.RATE_DATE
, POH.RATE
, POH.NOTE_TO_RECEIVER
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, POLL.ATTRIBUTE_CATEGORY
, POLL.ATTRIBUTE1
, POLL.ATTRIBUTE2
, POLL.ATTRIBUTE3
, POLL.ATTRIBUTE4
, POLL.ATTRIBUTE5
, POLL.ATTRIBUTE6
, POLL.ATTRIBUTE7
, POLL.ATTRIBUTE8
, POLL.ATTRIBUTE9
, POLL.ATTRIBUTE10
, POLL.ATTRIBUTE11
, POLL.ATTRIBUTE12
, POLL.ATTRIBUTE13
, POLL.ATTRIBUTE14
, POLL.ATTRIBUTE15
, POLL.CLOSED_CODE
, NULL
, NULL
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DCT.USER_CONVERSION_TYPE
, POLL.MATCH_OPTION
, POLL.COUNTRY_OF_ORIGIN_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, POLL.NOTE_TO_RECEIVER PLL_NOTE_TO_RECEIVER
, POLL.SECONDARY_QUANTITY SECONDARY_ORDERED_QTY
, POLL.SECONDARY_UNIT_OF_MEASURE SECONDARY_ORDERED_UOM
, POLL.PREFERRED_GRADE QC_GRADE
, TO_NUMBER(NULL)
, DECODE(MSI.TRACKING_QUANTITY_IND
, 'PS'
, MSI.SECONDARY_DEFAULT_IND
, NULL)
FROM PO_HEADERS POH
, PO_LINE_LOCATIONS POLL
, PO_LINES POL
, PO_RELEASES POR
, PO_VENDORS POV
, PO_HAZARD_CLASSES_TL POHC
, PO_UN_NUMBERS_TL POUN
, RCV_ROUTING_HEADERS RCVRH
, HR_LOCATIONS_ALL_TL HL
, MTL_SYSTEM_ITEMS MSI
, MTL_UNITS_OF_MEASURE MUM
, PO_LINE_TYPES_B POLT
, GL_DAILY_CONVERSION_TYPES DCT
WHERE 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 POH.PO_HEADER_ID = POLL.PO_HEADER_ID
AND POL.PO_LINE_ID = POLL.PO_LINE_ID
AND POL.HAZARD_CLASS_ID = POHC.HAZARD_CLASS_ID(+)
AND POHC.LANGUAGE(+) = USERENV('LANG')
AND POL.UN_NUMBER_ID = POUN.UN_NUMBER_ID (+)
AND POUN.LANGUAGE(+) = USERENV('LANG')
AND POLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
AND POLL.SHIP_TO_LOCATION_ID = HL.LOCATION_ID(+)
AND HL.LANGUAGE(+) = USERENV('LANG')
AND POH.VENDOR_ID = POV.VENDOR_ID(+)
AND POL.LINE_TYPE_ID = POLT.LINE_TYPE_ID(+)
AND POLL.RECEIVING_ROUTING_ID = RCVRH.ROUTING_HEADER_ID(+)
AND MUM.UNIT_OF_MEASURE (+) = POL.UNIT_MEAS_LOOKUP_CODE
AND NVL(MSI.ORGANIZATION_ID
, POLL.SHIP_TO_ORGANIZATION_ID) = POLL.SHIP_TO_ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID (+) = POL.ITEM_ID
AND DCT.CONVERSION_TYPE (+) = POH.RATE_TYPE
AND NVL( POH.CONSIGNED_CONSUMPTION_FLAG
, 'N') = 'N'
AND NVL( POR.CONSIGNED_CONSUMPTION_FLAG
, 'N') = 'N'
AND NVL(POL.MATCHING_BASIS
, 'QUANTITY') != 'AMOUNT'

Columns