DBA Data[Home] [Help]

VIEW: ICX.POS_ACK_SELECT#

Source

View Text - Preformatted

select ROW_NUM ROW_NUM, ACCEPTANCE_FLAG ACCEPTANCE_FLAG, ACCEPT ACCEPT, REJECT REJECT, ACCEPTANCE_TYPE_CODE ACCEPTANCE_TYPE_CODE, ACCEPTANCE_TYPE ACCEPTANCE_TYPE, COMMENTS COMMENTS, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, PO_NUMBER PO_NUMBER, RELEASE_NUMBER RELEASE_NUMBER, REVISION_NUMBER REVISION_NUMBER, DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE, DOCUMENT_TYPE DOCUMENT_TYPE, CURRENCY_CODE CURRENCY_CODE, TOTAL TOTAL, ACCEPTANCE_REQUIRED ACCEPTANCE_REQUIRED, ACCEPTANCE_STATUS ACCEPTANCE_STATUS, ACCEPTANCE_REQUIRED_BY ACCEPTANCE_REQUIRED_BY, APPROVAL_STATUS APPROVAL_STATUS, SHIPTO_LOCATION_ID SHIPTO_LOCATION_ID, SHIPTO_LOCATION SHIPTO_LOCATION, CARRIER_CODE CARRIER_CODE, CARRIER CARRIER, BUYER_ID BUYER_ID, BUYER_NAME BUYER_NAME, SUPPLIER_ORG_ID SUPPLIER_ORG_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_SITE SUPPLIER_SITE from "ICX"."POS_ACK_SELECT"
View Text - HTML Formatted

SELECT ROW_NUM ROW_NUM
, ACCEPTANCE_FLAG ACCEPTANCE_FLAG
, ACCEPT ACCEPT
, REJECT REJECT
, ACCEPTANCE_TYPE_CODE ACCEPTANCE_TYPE_CODE
, ACCEPTANCE_TYPE ACCEPTANCE_TYPE
, COMMENTS COMMENTS
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, PO_NUMBER PO_NUMBER
, RELEASE_NUMBER RELEASE_NUMBER
, REVISION_NUMBER REVISION_NUMBER
, DOCUMENT_TYPE_CODE DOCUMENT_TYPE_CODE
, DOCUMENT_TYPE DOCUMENT_TYPE
, CURRENCY_CODE CURRENCY_CODE
, TOTAL TOTAL
, ACCEPTANCE_REQUIRED ACCEPTANCE_REQUIRED
, ACCEPTANCE_STATUS ACCEPTANCE_STATUS
, ACCEPTANCE_REQUIRED_BY ACCEPTANCE_REQUIRED_BY
, APPROVAL_STATUS APPROVAL_STATUS
, SHIPTO_LOCATION_ID SHIPTO_LOCATION_ID
, SHIPTO_LOCATION SHIPTO_LOCATION
, CARRIER_CODE CARRIER_CODE
, CARRIER CARRIER
, BUYER_ID BUYER_ID
, BUYER_NAME BUYER_NAME
, SUPPLIER_ORG_ID SUPPLIER_ORG_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_SITE SUPPLIER_SITE
FROM "ICX"."POS_ACK_SELECT"