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.FV_CROSS_DOC_REF dependencies on AP_INVOICE_PAYMENTS

Line 295: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

291: WHERE pd.po_header_id = ph.po_header_id
292: AND pd.line_location_id = pll.line_location_id
293: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid
294: WHERE aid.po_distribution_id = pd.po_distribution_id
295: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
296: WHERE aip.invoice_id = aid.invoice_id
297: AND EXISTS (SELECT 1 FROM ap_checks ac
298: WHERE ac.check_id = aip.check_id
299: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 310: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

306: WHERE rt.po_header_id = ph.po_header_id
307: AND rt.po_line_location_id = pll.line_location_id
308: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
309: WHERE aid.rcv_transaction_id = rt.transaction_id
310: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
311: WHERE aip.invoice_id = aid.invoice_id
312: AND EXISTS (SELECT 1 FROM ap_checks ac
313: WHERE ac.check_id = aip.check_id
314: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 336: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

332: WHERE pd.po_header_id = ph.po_header_id
333: AND pd.line_location_id = pll.line_location_id
334: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid
335: WHERE aid.po_distribution_id = pd.po_distribution_id
336: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
337: WHERE aip.invoice_id = aid.invoice_id
338: AND EXISTS (SELECT 1 FROM ap_checks ac
339: WHERE ac.check_id = aip.check_id
340: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 351: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

347: WHERE rt.po_header_id = ph.po_header_id
348: AND rt.po_line_location_id = pll.line_location_id
349: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
350: WHERE aid.rcv_transaction_id = rt.transaction_id
351: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
352: WHERE aip.invoice_id = aid.invoice_id
353: AND EXISTS (SELECT 1 FROM ap_checks ac
354: WHERE ac.check_id = aip.check_id
355: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 665: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

661: AND EXISTS (SELECT 1 FROM po_distributions pd
662: WHERE pd.req_distribution_id = prd.distribution_id
663: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid
664: WHERE aid.po_distribution_id = pd.po_distribution_id
665: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
666: WHERE aip.invoice_id = aid.invoice_id
667: AND EXISTS (SELECT 1 FROM ap_checks ac
668: WHERE ac.check_id = aip.check_id
669: AND ac.vendor_id = vp_vendor_id

Line 683: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

679: AND EXISTS (SELECT 1 FROM rcv_transactions rt
680: WHERE rt.po_line_location_id = pll.line_location_id
681: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
682: WHERE aid.rcv_transaction_id = rt.transaction_id
683: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
684: WHERE aip.invoice_id = aid.invoice_id
685: AND EXISTS (SELECT 1 FROM ap_checks ac
686: WHERE ac.check_id = aip.check_id
687: AND ac.vendor_id = vp_vendor_id

Line 707: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

703: AND EXISTS (SELECT 1 FROM po_distributions pd
704: WHERE pd.req_distribution_id = prd.distribution_id
705: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid
706: WHERE aid.po_distribution_id = pd.po_distribution_id
707: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
708: WHERE aip.invoice_id = aid.invoice_id
709: AND EXISTS (SELECT 1 FROM ap_checks ac
710: WHERE ac.check_id = aip.check_id
711: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 723: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

719: AND EXISTS (SELECT 1 FROM rcv_transactions rt
720: WHERE rt.po_line_location_id = pll.line_location_id
721: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
722: WHERE aid.rcv_transaction_id = rt.transaction_id
723: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
724: WHERE aip.invoice_id = aid.invoice_id
725: AND EXISTS (SELECT 1 FROM ap_checks ac
726: WHERE ac.check_id = aip.check_id
727: AND ac.vendor_id = vp_vendor_id

Line 970: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

966: AND ph.vendor_site_id = vp_vendor_site_id
967: AND EXISTS (SELECT 1 FROM po_distributions pd WHERE pd.line_location_id = rt.po_line_location_id
968: AND EXISTS( SELECT 1 FROM ap_invoice_distributions aid
969: WHERE aid.po_distribution_id= pd.po_distribution_id
970: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
971: WHERE aip.invoice_id = aid.invoice_id
972: AND EXISTS (SELECT 1 FROM ap_checks ac
973: WHERE ac.check_id = aip.check_id
974: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 993: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

989: AND EXISTS (SELECT 1 FROM po_distributions pd
990: WHERE pd.line_location_id = rt.po_line_location_id
991: AND EXISTS( SELECT 1 FROM ap_invoice_distributions aid
992: WHERE aid.po_distribution_id= pd.po_distribution_id
993: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
994: WHERE aip.invoice_id = aid.invoice_id
995: AND EXISTS (SELECT 1 FROM ap_checks ac
996: WHERE ac.check_id = aip.check_id
997: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 1279: AND EXISTS ( SELECT 1 FROM ap_invoice_payments aip

1275: SELECT invoice_id FROM ap_invoices ai
1276: WHERE vendor_id = vp_vendor_id
1277: AND vendor_site_id = vp_vendor_site_id
1278: AND NOT EXISTS (SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
1279: AND EXISTS ( SELECT 1 FROM ap_invoice_payments aip
1280: WHERE aip.invoice_id = ai.invoice_id
1281: AND EXISTS (SELECT 1 FROM ap_checks ac
1282: WHERE ac.check_id = aip.check_id
1283: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 1296: AND EXISTS ( SELECT 1 FROM ap_invoice_payments aip

1292: AND vendor_site_id = vp_vendor_site_id
1293: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp
1294: WHERE invoice_id = ai.invoice_id
1295: AND session_id = vp_session_id)
1296: AND EXISTS ( SELECT 1 FROM ap_invoice_payments aip
1297: WHERE aip.invoice_id = ai.invoice_id
1298: AND EXISTS (SELECT 1 FROM ap_checks ac
1299: WHERE ac.check_id = aip.check_id
1300: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 1413: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

1409: SELECT check_id FROM ap_checks ac
1410: WHERE vendor_id = vp_vendor_id
1411: AND vendor_site_id = vp_vendor_site_id
1412: AND NOT EXISTS (SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
1413: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
1414: WHERE aip.check_id = ac.check_id
1415: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1416: WHERE aid.invoice_id = aip.invoice_id
1417: AND (EXISTS (SELECT 1 FROM po_distributions pd

Line 1449: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

1445: AND vendor_site_id = vp_vendor_site_id
1446: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp
1447: WHERE check_id = ac.check_id
1448: AND session_id = vp_session_id)
1449: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
1450: WHERE aip.check_id = ac.check_id
1451: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1452: WHERE aid.invoice_id = aip.invoice_id
1453: AND (EXISTS (SELECT 1 FROM po_distributions pd

Line 1484: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

1480: SELECT check_id FROM ap_checks ac
1481: WHERE vendor_id = vp_vendor_id
1482: AND vendor_site_id = vp_vendor_site_id
1483: AND NOT EXISTS (SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
1484: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
1485: WHERE aip.check_id = ac.check_id
1486: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1487: WHERE aid.invoice_id = aip.invoice_id
1488: AND (EXISTS (SELECT 1 FROM po_distributions pd

Line 1508: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

1504: AND vendor_site_id = vp_vendor_site_id
1505: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp
1506: WHERE check_id= ac.check_id
1507: AND session_id = vp_session_id)
1508: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
1509: WHERE aip.check_id = ac.check_id
1510: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1511: WHERE aid.invoice_id = aip.invoice_id
1512: AND (EXISTS (SELECT 1 FROM po_distributions pd

Line 1532: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

1528: SELECT check_id FROM ap_checks ac
1529: WHERE vendor_id = vp_vendor_id
1530: AND vendor_site_id = vp_vendor_site_id
1531: AND NOT EXISTS (SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
1532: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
1533: WHERE aip.check_id = ac.check_id
1534: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1535: WHERE aid.invoice_id = aip.invoice_id
1536: AND EXISTS (SELECT 1 FROM po_distributions pd WHERE pd.po_distribution_id = aid.po_distribution_id

Line 1550: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

1546: AND vendor_site_id = vp_vendor_site_id
1547: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp
1548: WHERE check_id = ac.check_id
1549: AND session_id = vp_session_id)
1550: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
1551: WHERE aip.check_id = ac.check_id
1552: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1553: WHERE aid.invoice_id = aip.invoice_id
1554: AND EXISTS (SELECT 1 FROM po_distributions pd WHERE pd.po_distribution_id = aid.po_distribution_id

Line 1570: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

1566: SELECT check_id FROM ap_checks ac
1567: WHERE vendor_id = vp_vendor_id
1568: AND vendor_site_id = vp_vendor_site_id
1569: AND NOT EXISTS (SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
1570: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
1571: WHERE aip.check_id = ac.check_id
1572: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1573: WHERE aid.invoice_id = aip.invoice_id
1574: AND EXISTS (SELECT 1 FROM ap_invoices ai

Line 1587: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip

1583: AND vendor_site_id = vp_vendor_site_id
1584: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp
1585: WHERE check_id = ac.check_id
1586: AND session_id = vp_session_id)
1587: AND EXISTS (SELECT 1 FROM ap_invoice_payments aip
1588: WHERE aip.check_id = ac.check_id
1589: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1590: WHERE aid.invoice_id = aip.invoice_id
1591: AND EXISTS (SELECT 1 FROM ap_invoices ai