[Home] [Help]
| Product: | ICX - Oracle iProcurement |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.POS_ACK_EDIT_V
|
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