View: INL_PO_SOURCE_LINES_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows expected receipts from Purchase Orders.
Implementation/DBA Data:	APPS.INL_PO_SOURCE_LINES_V

View Text

SELECT ER.LINE_CHKBOX
, ER.SOURCE_TYPE_CODE
, ER.RECEIPT_SOURCE_CODE
, ER.ORDER_TYPE_CODE
, ER.ORDER_TYPE
, ER.PO_HEADER_ID
, ER.PO_NUMBER
, ER.PO_LINE_ID
, ER.PO_LINE_NUMBER
, ER.PO_LINE_LOCATION_ID
, ER.PO_SHIPMENT_NUMBER
, ER.PO_RELEASE_ID
, ER.PO_RELEASE_NUMBER
, ER.REQ_HEADER_ID
, ER.REQ_NUMBER
, ER.REQ_LINE_ID
, ER.REQ_LINE
, ER.REQ_DISTRIBUTION_ID
, ER.RCV_SHIPMENT_HEADER_ID
, ER.RCV_SHIPMENT_NUMBER
, ER.RCV_SHIPMENT_LINE_ID
, ER.RCV_LINE_NUMBER
, ER.FROM_ORGANIZATION_ID
, ER.TO_ORGANIZATION_ID
, ER.VENDOR_ID
, ER.SOURCE
, ER.VENDOR_SITE_ID
, ER.OUTSIDE_OPERATION_FLAG
, ER.ITEM_ID
, ER.PRIMARY_UOM
, ER.PRIMARY_UOM_CLASS
, ER.ITEM_ALLOWED_UNITS_LOOKUP_CODE
, ER.ITEM_LOCATOR_CONTROL
, ER.RESTRICT_LOCATORS_CODE
, ER.RESTRICT_SUBINVENTORIES_CODE
, ER.SHELF_LIFE_CODE
, ER.SHELF_LIFE_DAYS
, ER.SERIAL_NUMBER_CONTROL_CODE
, ER.LOT_CONTROL_CODE
, ER.ITEM_REV_CONTROL_FLAG_TO
, ER.ITEM_REV_CONTROL_FLAG_FROM
, ER.ITEM_NUMBER
, ER.ITEM_REVISION
, ER.ITEM_DESCRIPTION
, ER.ITEM_CATEGORY_ID
, ER.HAZARD_CLASS
, ER.UN_NUMBER
, ER.VENDOR_ITEM_NUMBER
, ER.SHIP_TO_LOCATION_ID
, ER.SHIP_TO_LOCATION
, ER.PACKING_SLIP
, ER.ROUTING_ID
, ER.ROUTING_NAME
, ER.NEED_BY_DATE
, ER.EXPECTED_RECEIPT_DATE
, ER.ORDERED_QTY
, ER.ORDERED_UOM
, ER.USSGL_TRANSACTION_CODE
, ER.GOVERNMENT_CONTEXT
, ER.INSPECTION_REQUIRED_FLAG
, ER.RECEIPT_REQUIRED_FLAG
, ER.ENFORCE_SHIP_TO_LOCATION_CODE
, ER.UNIT_PRICE
, ER.CURRENCY_CODE
, ER.CURRENCY_CONVERSION_TYPE
, ER.CURRENCY_CONVERSION_DATE
, ER.CURRENCY_CONVERSION_RATE
, ER.NOTE_TO_RECEIVER
, ER.DESTINATION_TYPE_CODE
, ER.DELIVER_TO_PERSON_ID
, ER.DELIVER_TO_LOCATION_ID
, ER.DESTINATION_SUBINVENTORY
, ER.ATTRIBUTE_CATEGORY
, ER.ATTRIBUTE1
, ER.ATTRIBUTE2
, ER.ATTRIBUTE3
, ER.ATTRIBUTE4
, ER.ATTRIBUTE5
, ER.ATTRIBUTE6
, ER.ATTRIBUTE7
, ER.ATTRIBUTE8
, ER.ATTRIBUTE9
, ER.ATTRIBUTE10
, ER.ATTRIBUTE11
, ER.ATTRIBUTE12
, ER.ATTRIBUTE13
, ER.ATTRIBUTE14
, ER.ATTRIBUTE15
, ER.CLOSED_CODE
, ER.ASN_TYPE
, ER.BILL_OF_LADING
, ER.SHIPPED_DATE
, ER.FREIGHT_CARRIER_CODE
, ER.WAYBILL_AIRBILL_NUM
, ER.FREIGHT_BILL_NUM
, ER.VENDOR_LOT_NUM
, ER.CONTAINER_NUM
, ER.TRUCK_NUM
, ER.BAR_CODE_LABEL
, ER.RATE_TYPE_DISPLAY
, ER.MATCH_OPTION
, ER.COUNTRY_OF_ORIGIN_CODE
, ER.OE_ORDER_HEADER_ID
, ER.OE_ORDER_NUM
, ER.OE_ORDER_LINE_ID
, ER.OE_ORDER_LINE_NUM
, ER.CUSTOMER_ID
, ER.CUSTOMER_SITE_ID
, ER.CUSTOMER_ITEM_NUM
, ER.PLL_NOTE_TO_RECEIVER
, ER.SECONDARY_ORDERED_QTY
, ER.SECONDARY_ORDERED_UOM
, ER.QC_GRADE
, ER.LPN_ID
, ER.SECONDARY_DEFAULT_IND
, ER.ORG_ID
, ER.OE_ORDER_SHIP_NUM
, PV.PARTY_ID
, PVS.PARTY_SITE_ID
FROM PO_VENDOR_SITES_ALL PVS
, PO_VENDORS PV
, INL_ENTER_RECEIPTS_V ER
WHERE PVS.VENDOR_SITE_ID (+) = ER.VENDOR_SITE_ID
AND PV.VENDOR_ID (+) = ER.VENDOR_ID
AND ER.ORDER_TYPE_CODE = 'PO'

Columns