[Home] [Help]
View: OIE_SRS_CARD_NUMBER_V
View Text
SELECT DISTINCT CARD.CARD_ID
, ICC.MASKED_CC_NUMBER
, EMP.FULL_NAME
, CARD_PROG.CARD_PROGRAM_NAME
, CARD.ORG_ID
FROM AP_CARDS_ALL CARD
, AP_CARD_PROGRAMS_ALL CARD_PROG
, PER_EMPLOYEES_X EMP
, IBY_CREDITCARD ICC
WHERE CARD.CARD_PROGRAM_ID = CARD_PROG.CARD_PROGRAM_ID
AND CARD.EMPLOYEE_ID = EMP.EMPLOYEE_ID
AND CARD.CARD_REFERENCE_ID = ICC.INSTRID
Columns
Name |
CARD_ID |
CARD_NUMBER |
FULL_NAME |
CARD_PROGRAM_NAME |
ORG_ID |