VIEW: ICX.POS_ASN_SEARCH_RESULT#

Source

View Text - Preformatted

select SESSION_ID SESSION_ID, PO_HEADER_ID PO_HEADER_ID, PO_NUMBER PO_NUMBER, PO_RELEASE_ID PO_RELEASE_ID, PO_LINE_ID PO_LINE_ID, LINE_NUMBER LINE_NUMBER, PO_SHIPMENT_ID PO_SHIPMENT_ID, SHIPMENT_NUMBER SHIPMENT_NUMBER, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE, SUPPLIER_ITEM_NUMBER SUPPLIER_ITEM_NUMBER, ITEM_DESCRIPTION ITEM_DESCRIPTION, QUANTITY_ORDERED QUANTITY_ORDERED, UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE, DUE_DATE DUE_DATE, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE, SHIP_TO_ORGANIZATION_NAME SHIP_TO_ORGANIZATION_NAME, ITEM_ID ITEM_ID, ITEM_NUMBER ITEM_NUMBER, ITEM_REVISION ITEM_REVISION, CATEGORY_ID CATEGORY_ID, CATEGORY CATEGORY from "ICX"."POS_ASN_SEARCH_RESULT"

View Text - HTML Formatted

SELECT SESSION_ID SESSION_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_NUMBER PO_NUMBER
, PO_RELEASE_ID PO_RELEASE_ID
, PO_LINE_ID PO_LINE_ID
, LINE_NUMBER LINE_NUMBER
, PO_SHIPMENT_ID PO_SHIPMENT_ID
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE
, SUPPLIER_ITEM_NUMBER SUPPLIER_ITEM_NUMBER
, ITEM_DESCRIPTION ITEM_DESCRIPTION
, QUANTITY_ORDERED QUANTITY_ORDERED
, UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE
, DUE_DATE DUE_DATE
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_SITE_CODE SUPPLIER_SITE_CODE
, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_ORGANIZATION_NAME SHIP_TO_ORGANIZATION_NAME
, ITEM_ID ITEM_ID
, ITEM_NUMBER ITEM_NUMBER
, ITEM_REVISION ITEM_REVISION
, CATEGORY_ID CATEGORY_ID
, CATEGORY CATEGORY
FROM "ICX"."POS_ASN_SEARCH_RESULT"