VIEW: APPS.POS_ACK_EDIT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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