What is the difference among 5 of acceptance required flag (lookup code = 'P', 'D', 'Y', 'N', 'S') ?
Our customer has 5 lookup code value of "ACCEPTANCE_REQUIRED" PO Lookup codes.
SELECT lookup_code, meaning, created_by, creation_date
FROM po_lookup_codes
WHERE lookup_type = 'ACCEPTANCE_REQUIRED'
The results are below.
Lookup_Code Meaning Created_By Creation_Date
'D' Document 120 2003-08-18
'N' None 2 2003-08-18
'P' Proxy Signature 122 2009-09-01
'S' Signature 120 2003-08-18
'Y' Document or Shipment 120 2003-08-18
I've read the purchasing both manual 12.1 and 12.2, but the 'P' code is never mentioned
- I especially would like to know the usage of lookup code 'P' (Proxy Signagure).
- Additionally, I want to know that it is possible to create user defined lookup code using DML statement because of the customer's request. They use their custom supplier portal system instead of Oralce iSupplier portal product