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.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_FORMATS_VL

Line 964: FROM iby_formats_vl ppfformat

960: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
961: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
962: AND ppp.positive_pay_format_code IN
963: (SELECT ppfformat.format_code
964: FROM iby_formats_vl ppfformat
965: WHERE ppfformat.format_name = p_format_name)
966: AND xml_pmt_lvl.payment_date >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), xml_pmt_lvl.payment_date)
967: AND xml_pmt_lvl.payment_date <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
968: AND xml_pmt_lvl.payment_status IN('ISSUED', 'PAID')

Line 983: FROM iby_formats_vl ppfformat

979: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
980: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
981: AND ppp.positive_pay_format_code IN
982: (SELECT ppfformat.format_code
983: FROM iby_formats_vl ppfformat
984: WHERE ppfformat.format_name = p_format_name)
985: AND xml_pmt_lvl.payment_date >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), xml_pmt_lvl.payment_date)
986: AND xml_pmt_lvl.payment_date <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
987: AND xml_pmt_lvl.payment_status IN('ISSUED', 'PAID')

Line 1001: FROM iby_formats_vl ppfformat

997: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
998: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
999: AND ppp.positive_pay_format_code IN
1000: (SELECT ppfformat.format_code
1001: FROM iby_formats_vl ppfformat
1002: WHERE ppfformat.format_name = p_format_name)
1003: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date))
1004: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
1005: AND xml_pmt_lvl.payment_status IN('VOID')

Line 1020: FROM iby_formats_vl ppfformat

1016: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1017: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1018: AND ppp.positive_pay_format_code IN
1019: (SELECT ppfformat.format_code
1020: FROM iby_formats_vl ppfformat
1021: WHERE ppfformat.format_name = p_format_name)
1022: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date))
1023: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
1024: AND xml_pmt_lvl.payment_status IN('VOID')

Line 1038: FROM iby_formats_vl ppfformat

1034: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1035: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1036: AND ppp.positive_pay_format_code IN
1037: (SELECT ppfformat.format_code
1038: FROM iby_formats_vl ppfformat
1039: WHERE ppfformat.format_name = p_format_name)
1040: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date))
1041: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
1042: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')

Line 1057: FROM iby_formats_vl ppfformat

1053: FROM iby_xml_fd_pmt_1_0_v xml_pmt_lvl,iby_payment_profiles ppp
1054: WHERE xml_pmt_lvl.payment_profile_id = ppp.payment_profile_id
1055: AND ppp.positive_pay_format_code IN
1056: (SELECT ppfformat.format_code
1057: FROM iby_formats_vl ppfformat
1058: WHERE ppfformat.format_name = p_format_name)
1059: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) >= nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'), decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date))
1060: AND decode(xml_pmt_lvl.payment_status,'VOID',xml_pmt_lvl.void_date,xml_pmt_lvl.payment_date) <= nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
1061: AND xml_pmt_lvl.payment_status IN('VOID','ISSUED','PAID')

Line 1337: iby_formats_vl ppfformat,

1333: SELECT pmt.payment_id,pmt.payment_instruction_id
1334: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1335: FROM iby_xml_fd_pmt_1_0_v pmt,
1336: iby_payment_profiles ppp,
1337: iby_formats_vl ppfformat,
1338: ce_bank_accounts ba
1339: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1340: AND ppp.positive_pay_format_code = ppfformat.format_code
1341: AND pmt.internal_bank_account_id = ba.bank_account_id

Line 1361: iby_formats_vl ppfformat,

1357: SELECT pmt.payment_id,pmt.payment_instruction_id
1358: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1359: FROM iby_xml_fd_pmt_1_0_v pmt,
1360: iby_payment_profiles ppp,
1361: iby_formats_vl ppfformat,
1362: ce_bank_accounts ba
1363: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1364: AND ppp.positive_pay_format_code = ppfformat.format_code
1365: AND pmt.internal_bank_account_id = ba.bank_account_id

Line 1389: iby_formats_vl ppfformat,

1385: SELECT pmt.payment_id,pmt.payment_instruction_id
1386: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1387: FROM iby_xml_fd_pmt_1_0_v pmt,
1388: iby_payment_profiles ppp,
1389: iby_formats_vl ppfformat,
1390: ce_bank_accounts ba
1391: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1392: AND ppp.positive_pay_format_code = ppfformat.format_code
1393: AND pmt.internal_bank_account_id = ba.bank_account_id

Line 1412: iby_formats_vl ppfformat,

1408: SELECT pmt.payment_id,pmt.payment_instruction_id
1409: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1410: FROM iby_xml_fd_pmt_1_0_v pmt,
1411: iby_payment_profiles ppp,
1412: iby_formats_vl ppfformat,
1413: ce_bank_accounts ba
1414: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1415: AND ppp.positive_pay_format_code = ppfformat.format_code
1416: AND pmt.internal_bank_account_id = ba.bank_account_id

Line 1440: iby_formats_vl ppfformat,

1436: SELECT pmt.payment_id,pmt.payment_instruction_id
1437: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1438: FROM iby_xml_fd_pmt_1_0_v pmt,
1439: iby_payment_profiles ppp,
1440: iby_formats_vl ppfformat,
1441: ce_bank_accounts ba
1442: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1443: AND ppp.positive_pay_format_code = ppfformat.format_code
1444: AND pmt.internal_bank_account_id = ba.bank_account_id

Line 1464: iby_formats_vl ppfformat,

1460: SELECT pmt.payment_id,pmt.payment_instruction_id
1461: BULK COLLECT INTO l_paymentid_arr,l_paymentinstrid_arr
1462: FROM iby_xml_fd_pmt_1_0_v pmt,
1463: iby_payment_profiles ppp,
1464: iby_formats_vl ppfformat,
1465: ce_bank_accounts ba
1466: WHERE pmt.payment_profile_id = ppp.payment_profile_id
1467: AND ppp.positive_pay_format_code = ppfformat.format_code
1468: AND pmt.internal_bank_account_id = ba.bank_account_id