SQL-075: clsRevokeReasonCodeCollection retrieve all¶
Retrieves all revoke reason code records from PAYMENT_OWNER.REVOKE_REASON_CODE.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-075 |
| Operation type | Read |
| Execution method | Inline SQL |
| Database | Oracle* |
| Schema | PAYMENT_OWNER |
| Command type | Text |
| Business object | clsRevokeReasonCodeCollection |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve / AfterRetrieve |
Parameters¶
This statement has no input parameters.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| PAYMENT_OWNER.REVOKE_REASON_CODE | Read | CODE, CODE_DESCR, INTERNAL_FLAG |
Sample SQL¶
Select REVOKE_REASON_CODE.CODE as Code,
REVOKE_REASON_CODE.CODE_DESCR as CodeDescr,
REVOKE_REASON_CODE.INTERNAL_FLAG as InternalFlag
From PAYMENT_OWNER.REVOKE_REASON_CODE
Operations and processes¶
Note: Statements marked with
*were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Payment.EFT\clsRevokeReasonCodeCollection.vb