[Home] [Help]
View: POS_ACK_EDIT_V
View Text
SELECT "ROW_NUM"
, "ACCEPTANCE_FLAG"
, "ACCEPT"
, "REJECT"
, "ACCEPTANCE_TYPE_CODE"
, "ACCEPTANCE_TYPE"
, "COMMENTS"
, "PO_HEADER_ID"
, "PO_RELEASE_ID"
, "PO_NUMBER"
, "RELEASE_NUMBER"
, "REVISION_NUMBER"
, "DOCUMENT_TYPE_CODE"
, "DOCUMENT_TYPE"
, "CURRENCY_CODE"
, "TOTAL"
, "ACCEPTANCE_REQUIRED"
, "ACCEPTANCE_STATUS"
, "ACCEPTANCE_REQUIRED_BY"
, "APPROVAL_STATUS"
, "SHIPTO_LOCATION_ID"
, "SHIPTO_LOCATION"
, "CARRIER_CODE"
, "CARRIER"
, "BUYER_ID"
, "BUYER_NAME"
, "SUPPLIER_ORG_ID"
, "SUPPLIER_ID"
, "SUPPLIER_NAME"
, "SUPPLIER_SITE_ID"
, "SUPPLIER_SITE"
FROM POS_ACK_SELECT ORDER BY PO_NUMBER
Columns
Name |
ROW_NUM |
ACCEPTANCE_FLAG |
ACCEPT |
REJECT |
ACCEPTANCE_TYPE_CODE |
ACCEPTANCE_TYPE |
COMMENTS |
PO_HEADER_ID |
PO_RELEASE_ID |
PO_NUMBER |
RELEASE_NUMBER |
REVISION_NUMBER |
DOCUMENT_TYPE_CODE |
DOCUMENT_TYPE |
CURRENCY_CODE |
TOTAL |
ACCEPTANCE_REQUIRED |
ACCEPTANCE_STATUS |
ACCEPTANCE_REQUIRED_BY |
APPROVAL_STATUS |
SHIPTO_LOCATION_ID |
SHIPTO_LOCATION |
CARRIER_CODE |
CARRIER |
BUYER_ID |
BUYER_NAME |
SUPPLIER_ORG_ID |
SUPPLIER_ID |
SUPPLIER_NAME |
SUPPLIER_SITE_ID |
SUPPLIER_SITE |