[Home] [Help]
| Product: | ICX - Oracle iProcurement |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.POS_ASN_RESULT_V
|
SELECT SESSION_ID
, PO_HEADER_ID
, PO_NUMBER
, PO_RELEASE_ID
, PO_LINE_ID
, LINE_NUMBER
, PO_SHIPMENT_ID
, SHIPMENT_NUMBER
, SHIP_TO_LOCATION_ID
, SHIP_TO_LOCATION_CODE
, SUPPLIER_ITEM_NUMBER
, ITEM_DESCRIPTION
, QUANTITY_ORDERED
, UNIT_OF_MEASURE_CODE
, DUE_DATE
, SUPPLIER_ID
, SUPPLIER_NAME
, SUPPLIER_SITE_ID
, SUPPLIER_SITE_CODE
, SHIP_TO_ORGANIZATION_ID
, SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_ORGANIZATION_NAME
, ITEM_ID
, ITEM_NUMBER
, ITEM_REVISION
, CATEGORY_ID
, CATEGORY
, SUPPLIER_ID
, SUPPLIER_SITE_ID
FROM POS_ASN_SEARCH_RESULT