VIEW: APPS.INL_PO_SOURCE_LINES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'