[Home] [Help]
View: 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 |