View: INL_ENTER_RECEIPTS_PO_V

Product:	INL - Oracle Landed Cost Management
Description:	A supplementary view used to simplify UI coding (Cloned from RCV_ENTER_RECEIPTS_PO_V).
Implementation/DBA Data:	APPS.INL_ENTER_RECEIPTS_PO_V

View Text

SELECT 'N' LINE_CHKBOX
, 'VENDOR' SOURCE_TYPE_CODE
, 'VENDOR' RECEIPT_SOURCE_CODE
, 'PO' ORDER_TYPE_CODE
, POH.TYPE_LOOKUP_CODE ORDER_TYPE
, POLL.PO_HEADER_ID PO_HEADER_ID
, POH.SEGMENT1 PO_NUMBER
, POLL.PO_LINE_ID PO_LINE_ID
, POL.LINE_NUM PO_LINE_NUMBER
, POLL.LINE_LOCATION_ID PO_LINE_LOCATION_ID
, POLL.SHIPMENT_NUM PO_SHIPMENT_NUMBER
, POLL.PO_RELEASE_ID PO_RELEASE_ID
, POR.RELEASE_NUM PO_RELEASE_NUMBER
, TO_NUMBER(NULL) REQ_HEADER_ID
, NULL REQ_NUMBER
, TO_NUMBER(NULL) REQ_LINE_ID
, TO_NUMBER(NULL) REQ_LINE
, TO_NUMBER(NULL) REQ_DISTRIBUTION_ID
, TO_NUMBER( NULL) RCV_SHIPMENT_HEADER_ID
, NULL RCV_SHIPMENT_NUMBER
, TO_NUMBER( NULL) RCV_SHIPMENT_LINE_ID
, TO_NUMBER( NULL) RCV_LINE_NUMBER
, POH.PO_HEADER_ID FROM_ORGANIZATION_ID
, POLL.SHIP_TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, POH.VENDOR_ID VENDOR_ID
, POV.VENDOR_NAME SOURCE
, POH.VENDOR_SITE_ID VENDOR_SITE_ID
, NVL(POLT.OUTSIDE_OPERATION_FLAG
, 'N') OUTSIDE_OPERATION_FLAG
, POL.ITEM_ID ITEM_ID
, POL.UNIT_MEAS_LOOKUP_CODE PRIMARY_UOM
, MUM.UOM_CLASS PRIMARY_UOM_CLASS
, NVL(MSI.ALLOWED_UNITS_LOOKUP_CODE
, 2) ITEM_ALLOWED_UNITS_LOOKUP_CODE
, NVL(MSI.LOCATION_CONTROL_CODE
, 1) ITEM_LOCATOR_CONTROL
, DECODE(MSI.RESTRICT_LOCATORS_CODE
, 1
, 'Y'
, 'N') RESTRICT_LOCATORS_CODE
, DECODE(MSI.RESTRICT_SUBINVENTORIES_CODE
, 1
, 'Y'
, 'N') RESTRICT_SUBINVENTORIES_CODE
, NVL(MSI.SHELF_LIFE_CODE
, 1) SHELF_LIFE_CODE
, NVL(MSI.SHELF_LIFE_DAYS
, 0) SHELF_LIFE_DAYS
, MSI.SERIAL_NUMBER_CONTROL_CODE SERIAL_NUMBER_CONTROL_CODE
, MSI.LOT_CONTROL_CODE LOT_CONTROL_CODE
, DECODE(MSI.REVISION_QTY_CONTROL_CODE
, 1
, 'N'
, 2
, 'Y'
, 'N') ITEM_REV_CONTROL_FLAG_TO
, NULL ITEM_REV_CONTROL_FLAG_FROM
, NULL ITEM_NUMBER
, POL.ITEM_REVISION ITEM_REVISION
, POL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, POL.CATEGORY_ID ITEM_CATEGORY_ID
, POHC.HAZARD_CLASS HAZARD_CLASS
, POUN.UN_NUMBER UN_NUMBER
, POL.VENDOR_PRODUCT_NUM VENDOR_ITEM_NUMBER
, POLL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, HL.LOCATION_CODE SHIP_TO_LOCATION
, NULL PACKING_SLIP
, POLL.RECEIVING_ROUTING_ID ROUTING_ID
, RCVRH.ROUTING_NAME ROUTING_NAME
, POLL.NEED_BY_DATE NEED_BY_DATE
, NVL(POLL.PROMISED_DATE
, POLL.NEED_BY_DATE) EXPECTED_RECEIPT_DATE
, POLL.QUANTITY ORDERED_QTY
, POL.UNIT_MEAS_LOOKUP_CODE ORDERED_UOM
, NULL USSGL_TRANSACTION_CODE
, POLL.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, POLL.INSPECTION_REQUIRED_FLAG INSPECTION_REQUIRED_FLAG
, POLL.RECEIPT_REQUIRED_FLAG RECEIPT_REQUIRED_FLAG
, POLL.ENFORCE_SHIP_TO_LOCATION_CODE ENFORCE_SHIP_TO_LOCATION_CODE
, NVL(POLL.PRICE_OVERRIDE
, POL.UNIT_PRICE) UNIT_PRICE
, POH.CURRENCY_CODE CURRENCY_CODE
, POH.RATE_TYPE CURRENCY_CONVERSION_TYPE
, POH.RATE_DATE CURRENCY_CONVERSION_DATE
, POH.RATE CURRENCY_CONVERSION_RATE
, POH.NOTE_TO_RECEIVER NOTE_TO_RECEIVER
, NULL DESTINATION_TYPE_CODE
, TO_NUMBER(NULL) DELIVER_TO_PERSON_ID
, TO_NUMBER(NULL) DELIVER_TO_LOCATION_ID
, NULL DESTINATION_SUBINVENTORY
, POLL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, POLL.ATTRIBUTE1 ATTRIBUTE1
, POLL.ATTRIBUTE2 ATTRIBUTE2
, POLL.ATTRIBUTE3 ATTRIBUTE3
, POLL.ATTRIBUTE4 ATTRIBUTE4
, POLL.ATTRIBUTE5 ATTRIBUTE5
, POLL.ATTRIBUTE6 ATTRIBUTE6
, POLL.ATTRIBUTE7 ATTRIBUTE7
, POLL.ATTRIBUTE8 ATTRIBUTE8
, POLL.ATTRIBUTE9 ATTRIBUTE9
, POLL.ATTRIBUTE10 ATTRIBUTE10
, POLL.ATTRIBUTE11 ATTRIBUTE11
, POLL.ATTRIBUTE12 ATTRIBUTE12
, POLL.ATTRIBUTE13 ATTRIBUTE13
, POLL.ATTRIBUTE14 ATTRIBUTE14
, POLL.ATTRIBUTE15 ATTRIBUTE15
, POLL.CLOSED_CODE CLOSED_CODE
, NULL ASN_TYPE
, NULL BILL_OF_LADING
, TO_DATE(NULL) SHIPPED_DATE
, NULL FREIGHT_CARRIER_CODE
, NULL WAYBILL_AIRBILL_NUM
, NULL FREIGHT_BILL_NUM
, NULL VENDOR_LOT_NUM
, NULL CONTAINER_NUM
, NULL TRUCK_NUM
, NULL BAR_CODE_LABEL
, DCT.USER_CONVERSION_TYPE RATE_TYPE_DISPLAY
, POLL.MATCH_OPTION MATCH_OPTION
, POLL.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE
, TO_NUMBER(NULL) OE_ORDER_HEADER_ID
, TO_NUMBER(NULL) OE_ORDER_NUM
, TO_NUMBER(NULL) OE_ORDER_LINE_ID
, TO_NUMBER(NULL) OE_ORDER_LINE_NUM
, TO_NUMBER(NULL) CUSTOMER_ID
, TO_NUMBER(NULL) CUSTOMER_SITE_ID
, NULL CUSTOMER_ITEM_NUM
, 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) LPN_ID
, DECODE(MSI.TRACKING_QUANTITY_IND
, 'PS'
, MSI.SECONDARY_DEFAULT_IND
, NULL) SECONDARY_DEFAULT_IND
, POLL.ORG_ID ORG_ID
, TO_NUMBER(NULL) OE_ORDER_SHIP_NUM
, TO_NUMBER( NULL) LCM_SHIPMENT_LINE_ID
, TO_NUMBER( NULL) UNIT_LANDED_COST
, POLL.LCM_FLAG LCM_SHIPMENT_FLAG
FROM PO_HEADERS_ALL POH
, PO_LINE_LOCATIONS POLL
, PO_LINES_ALL POL
, PO_RELEASES_ALL 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(POLL.MATCHING_BASIS
, 'QUANTITY') != 'AMOUNT'
AND POLL.PAYMENT_TYPE IS NULL
AND NVL(POLL.LCM_FLAG
, 'N') = 'Y'

Columns