VIEW: APPS.AP_CARDS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)