[Home] [Help]
View: APBV_CARDS
Product: | AP - Payables |
Description: | |
Implementation/DBA Data: |
APPS.APBV_CARDS
|
View Text
SELECT ACA.EMPLOYEE_ID
, ACA.CARD_ID
, ACA.LIMIT_OVERRIDE_AMOUNT
, ACA.TRX_LIMIT_OVERRIDE_AMOUNT
, ACA.PROFILE_ID
, ACA.CARDMEMBER_NAME
, ACA.DEPARTMENT_NAME
, ACA.PHYSICAL_CARD_FLAG
, ACA.PAPER_STATEMENT_REQ_FLAG
, ACA.LOCATION_ID
, ACA.DESCRIPTION
, ACA.ORG_ID
, ACA.INACTIVE_DATE
, ACA.LAST_UPDATE_DATE
, ACA.LAST_UPDATED_BY
, ACA.CREATION_DATE
, ACA.CREATED_BY
, '_DF:SQLAP:AP_CARDS:ACA'
, ACA.CARD_EXPIRATION_DATE
, ACA.CARD_PROGRAM_ID
, ACA.REQUEST_ID
, ACA.CARD_REFERENCE_ID
FROM AP_CARDS_ALL ACA
WHERE '_SEC:ACA.ORG_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
EMPLOYEE_ID |
CARD_ID |
LIMIT_OVERRIDE_AMOUNT |
TRX_LIMIT_OVERRIDE_AMOUNT |
PROFILE_ID |
CARDMEMBER_NAME |
DEPARTMENT_NAME |
PHYSICAL_CARD_FLAG |
PAPER_STATEMENT_REQ_FLAG |
LOCATION_ID |
DESCRIPTION |
ORG_ID |
INACTIVE_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
_DF |
CARD_EXPIRATION_DATE |
CARD_PROGRAM_ID |
REQUEST_ID |
CARD_REFERENCE_ID |