FND Design Data [Home] [Help]

View: POS_ASN_RESULT_V

Product: ICX - Oracle iProcurement
Description:
Implementation/DBA Data: ViewAPPS.POS_ASN_RESULT_V
View Text

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

Columns

Name
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
SEC_SUPPLIER_ID
SEC_SUPPLIER_SITE_ID