Product: | AP - Payables |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.AP_CARDS_V |
SELECT AC.ROWID ROW_ID
, AC.EMPLOYEE_ID
, AC.CARD_NUMBER
, AC.CARD_ID
, AC.LIMIT_OVERRIDE_AMOUNT
, AC.TRX_LIMIT_OVERRIDE_AMOUNT
, AC.PROFILE_ID
, AC.CARDMEMBER_NAME
, AC.DEPARTMENT_NAME
, AC.PHYSICAL_CARD_FLAG
, AC.PAPER_STATEMENT_REQ_FLAG
, AC.LOCATION_ID
, AC.MOTHERS_MAIDEN_NAME
, AC.DESCRIPTION
, AC.ORG_ID
, AC.INACTIVE_DATE
, AC.LAST_UPDATE_DATE
, AC.LAST_UPDATED_BY
, AC.LAST_UPDATE_LOGIN
, AC.CREATION_DATE
, AC.CREATED_BY
, AC.ATTRIBUTE_CATEGORY
, AC.ATTRIBUTE1
, AC.ATTRIBUTE2
, AC.ATTRIBUTE3
, AC.ATTRIBUTE4
, AC.ATTRIBUTE5
, AC.ATTRIBUTE6
, AC.ATTRIBUTE7
, AC.ATTRIBUTE8
, AC.ATTRIBUTE9
, AC.ATTRIBUTE10
, AC.ATTRIBUTE11
, AC.ATTRIBUTE12
, AC.ATTRIBUTE13
, AC.ATTRIBUTE14
, AC.ATTRIBUTE15
, AC.ATTRIBUTE16
, AC.ATTRIBUTE17
, AC.ATTRIBUTE18
, AC.ATTRIBUTE19
, AC.ATTRIBUTE20
, AC.ATTRIBUTE21
, AC.ATTRIBUTE22
, AC.ATTRIBUTE23
, AC.ATTRIBUTE24
, AC.ATTRIBUTE25
, AC.ATTRIBUTE26
, AC.ATTRIBUTE27
, AC.ATTRIBUTE28
, AC.ATTRIBUTE29
, AC.ATTRIBUTE30
, P.FULL_NAME FULL_NAME
, P.EMPLOYEE_NUMBER
, ACP.PROFILE_NAME
, ACPR.CARD_PROGRAM_NAME
, P.NATIONAL_IDENTIFIER
, P.DATE_OF_BIRTH BIRTHDATE
, AC.CARD_EXPIRATION_DATE
, AC.CARD_PROGRAM_ID
, AC.CARD_REFERENCE_ID
, AC.PAYCARD_REFERENCE_ID
FROM AP_CARDS AC
, AP_CARD_PROGRAMS ACPR
, AP_CARD_PROFILES ACP
, PER_PEOPLE_X P
WHERE AC.PROFILE_ID = ACP.PROFILE_ID(+)
AND ACPR.CARD_PROGRAM_ID = AC.CARD_PROGRAM_ID
AND AC.EMPLOYEE_ID = P.PERSON_ID(+)