eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_APXCCOUT_XMLP_PKG dependencies on AP_CARDS_ALL

Line 463: AP_CARDS_ALL AC

459: CCT.BILLED_CURRENCY_CODE,
460: CCT.TRX_ID
461: FROM
462: AP_CREDIT_CARD_TRXNS CCT,
463: AP_CARDS_ALL AC
464: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
465: AND CCT.VALIDATE_CODE = 'Y'
466: AND CCT.PAYMENT_FLAG <> 'Y'
467: AND NVL(CCT.CATEGORY

Line 506: AP_CARDS_ALL AC

502: CCT.BILLED_CURRENCY_CODE,
503: CCT.TRX_ID
504: FROM
505: AP_CREDIT_CARD_TRXNS CCT,
506: AP_CARDS_ALL AC
507: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
508: AND CCT.VALIDATE_CODE = 'Y'
509: AND CCT.PAYMENT_FLAG <> 'Y'
510: AND NVL(CCT.CATEGORY

Line 543: AP_CARDS_ALL AC

539: CCT.BILLED_CURRENCY_CODE,
540: CCT.TRX_ID
541: FROM
542: AP_CREDIT_CARD_TRXNS CCT,
543: AP_CARDS_ALL AC
544: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
545: AND CCT.VALIDATE_CODE = 'Y'
546: AND CCT.PAYMENT_FLAG <> 'Y'
547: AND NVL(CCT.CATEGORY

Line 580: AP_CARDS_ALL AC,

576: CCT.BILLED_CURRENCY_CODE,
577: CCT.TRX_ID
578: FROM
579: AP_CREDIT_CARD_TRXNS CCT,
580: AP_CARDS_ALL AC,
581: AP_EXPENSE_REPORT_HEADERS ERH
582: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
583: AND CCT.VALIDATE_CODE = 'Y'
584: AND CCT.PAYMENT_FLAG <> 'Y'

Line 625: AP_CARDS_ALL AC,

621: CCT.BILLED_CURRENCY_CODE,
622: CCT.TRX_ID
623: FROM
624: AP_CREDIT_CARD_TRXNS CCT,
625: AP_CARDS_ALL AC,
626: AP_EXPENSE_REPORT_HEADERS ERH
627: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
628: AND CCT.VALIDATE_CODE = 'Y'
629: AND CCT.PAYMENT_FLAG <> 'Y'

Line 662: AP_CARDS_ALL AC,

658: CCT.BILLED_CURRENCY_CODE,
659: CCT.TRX_ID
660: FROM
661: AP_CREDIT_CARD_TRXNS CCT,
662: AP_CARDS_ALL AC,
663: AP_EXPENSE_REPORT_LINES ERL,
664: AP_EXPENSE_REPORT_HEADERS ERH
665: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
666: AND CCT.VALIDATE_CODE = 'Y'

Line 866: AP_CARDS_ALL AC

862: SELECT
863: AC.EMPLOYEE_ID
864: FROM
865: AP_CREDIT_CARD_TRXNS CCT,
866: AP_CARDS_ALL AC
867: WHERE CCT.CARD_PROGRAM_ID = P_CARD_PROGRAM_ID
868: AND CCT.VALIDATE_CODE = 'Y'
869: AND CCT.PAYMENT_FLAG <> 'Y'
870: AND NVL(CCT.EXPENSED_AMOUNT

Line 1412: AP_CARDS_ALL AC

1408: CCT.BILLED_CURRENCY_CODE BILLED_CURRENCY_CODE,
1409: SUM(CCT.BILLED_AMOUNT) TOTAL_AMT_POSTED
1410: FROM
1411: AP_CREDIT_CARD_TRXNS CCT,
1412: AP_CARDS_ALL AC
1413: WHERE AC.CARD_PROGRAM_ID = CCT.CARD_PROGRAM_ID
1414: AND AC.CARD_ID = CCT.CARD_ID
1415: AND CCT.TRX_ID in (
1416: SELECT

Line 1420: AP_CARDS_ALL AC,

1416: SELECT
1417: CCT.TRX_ID
1418: FROM
1419: AP_CREDIT_CARD_TRXNS CCT,
1420: AP_CARDS_ALL AC,
1421: AP_CARD_PROGRAMS_ALL CP,
1422: PER_PEOPLE_F PERF,
1423: PER_ASSIGNMENTS_F PERA,
1424: PER_ASSIGNMENT_STATUS_TYPES PERAS

Line 1459: AP_CARDS_ALL AC,

1455: SELECT
1456: CCT.TRX_ID
1457: FROM
1458: AP_CREDIT_CARD_TRXNS CCT,
1459: AP_CARDS_ALL AC,
1460: AP_CARD_PROGRAMS_ALL CP,
1461: PER_PEOPLE_F PERF,
1462: PER_ASSIGNMENTS_F PERA,
1463: PER_ASSIGNMENT_STATUS_TYPES PERAS,

Line 1507: AP_CARDS_ALL AC,

1503: DISTINCT
1504: CCT.TRX_ID
1505: FROM
1506: AP_CREDIT_CARD_TRXNS CCT,
1507: AP_CARDS_ALL AC,
1508: AP_CARD_PROGRAMS_ALL CP,
1509: PER_PEOPLE_F PERF,
1510: PER_ASSIGNMENTS_F PERA,
1511: PER_ASSIGNMENT_STATUS_TYPES PERAS

Line 1547: AP_CARDS_ALL AC,

1543: DISTINCT
1544: CCT.TRX_ID
1545: FROM
1546: AP_CREDIT_CARD_TRXNS CCT,
1547: AP_CARDS_ALL AC,
1548: AP_CARD_PROGRAMS_ALL CP,
1549: PER_PEOPLE_F PERF,
1550: PER_ASSIGNMENTS_F PERA,
1551: PER_ASSIGNMENT_STATUS_TYPES PERAS,