View: OIE_SRS_CARD_NUMBER_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.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