Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.PO_ASL_STATUS_RULES_V |
SELECT PASR.ROWID
, PASR.ALLOW_ACTION_FLAG
, PLC.DISPLAYED_FIELD
, PASR.BUSINESS_RULE
, PLC.DESCRIPTION
, PASR.STATUS_ID
, PASR.LAST_UPDATE_DATE
, PASR.LAST_UPDATE_LOGIN
, PASR.LAST_UPDATED_BY
, PASR.CREATION_DATE
, PASR.CREATED_BY
, PASR.REQUEST_ID
, PASR.PROGRAM_APPLICATION_ID
, PASR.PROGRAM_ID
, PASR.PROGRAM_UPDATE_DATE
FROM PO_LOOKUP_CODES PLC
, PO_ASL_STATUS_RULES PASR
WHERE PLC.LOOKUP_CODE = PASR.BUSINESS_RULE
AND PLC.LOOKUP_TYPE = 'ASL_STATUS_BUSINESS_RULES'