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_CHECKS

Line 19: vp_check_id ap_checks.check_id%TYPE;

15: vp_invoice_id ap_invoices.invoice_id%TYPE;
16: vp_invoice_date ap_invoices.invoice_date%TYPE;
17: vp_invoice_amount ap_invoices.invoice_amount%TYPE;
18: vp_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
19: vp_check_id ap_checks.check_id%TYPE;
20: vp_check_date ap_checks.creation_date%TYPE;
21: vp_amount ap_checks.amount%TYPE;
22: vp_treasury_pay_number ap_checks.treasury_pay_number%TYPE;
23: vp_treasury_pay_date ap_checks.treasury_pay_date%TYPE;

Line 20: vp_check_date ap_checks.creation_date%TYPE;

16: vp_invoice_date ap_invoices.invoice_date%TYPE;
17: vp_invoice_amount ap_invoices.invoice_amount%TYPE;
18: vp_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
19: vp_check_id ap_checks.check_id%TYPE;
20: vp_check_date ap_checks.creation_date%TYPE;
21: vp_amount ap_checks.amount%TYPE;
22: vp_treasury_pay_number ap_checks.treasury_pay_number%TYPE;
23: vp_treasury_pay_date ap_checks.treasury_pay_date%TYPE;
24: vp_valid_req_supplier NUMBER;

Line 21: vp_amount ap_checks.amount%TYPE;

17: vp_invoice_amount ap_invoices.invoice_amount%TYPE;
18: vp_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
19: vp_check_id ap_checks.check_id%TYPE;
20: vp_check_date ap_checks.creation_date%TYPE;
21: vp_amount ap_checks.amount%TYPE;
22: vp_treasury_pay_number ap_checks.treasury_pay_number%TYPE;
23: vp_treasury_pay_date ap_checks.treasury_pay_date%TYPE;
24: vp_valid_req_supplier NUMBER;
25: vp_supplier_name po_vendors.vendor_name%TYPE;

Line 22: vp_treasury_pay_number ap_checks.treasury_pay_number%TYPE;

18: vp_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;
19: vp_check_id ap_checks.check_id%TYPE;
20: vp_check_date ap_checks.creation_date%TYPE;
21: vp_amount ap_checks.amount%TYPE;
22: vp_treasury_pay_number ap_checks.treasury_pay_number%TYPE;
23: vp_treasury_pay_date ap_checks.treasury_pay_date%TYPE;
24: vp_valid_req_supplier NUMBER;
25: vp_supplier_name po_vendors.vendor_name%TYPE;
26: vp_supplier_site po_vendor_sites.vendor_site_code%TYPE;

Line 23: vp_treasury_pay_date ap_checks.treasury_pay_date%TYPE;

19: vp_check_id ap_checks.check_id%TYPE;
20: vp_check_date ap_checks.creation_date%TYPE;
21: vp_amount ap_checks.amount%TYPE;
22: vp_treasury_pay_number ap_checks.treasury_pay_number%TYPE;
23: vp_treasury_pay_date ap_checks.treasury_pay_date%TYPE;
24: vp_valid_req_supplier NUMBER;
25: vp_supplier_name po_vendors.vendor_name%TYPE;
26: vp_supplier_site po_vendor_sites.vendor_site_code%TYPE;
27: vp_session_id NUMBER;

Line 56: p_check_id IN ap_checks.check_id%TYPE,

52: p_invoice_id IN ap_invoices.invoice_id%TYPE,
53: p_invoice_date IN ap_invoices.invoice_date%TYPE ,
54: p_invoice_amount IN ap_invoices.invoice_amount%TYPE ,
55: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE ,
56: p_check_id IN ap_checks.check_id%TYPE,
57: p_check_date IN ap_checks.creation_date%TYPE,
58: p_amount IN ap_checks.amount%TYPE,
59: p_treasury_pay_number IN ap_checks.treasury_pay_number%TYPE,
60: p_treasury_pay_date IN ap_checks.treasury_pay_date%TYPE,

Line 57: p_check_date IN ap_checks.creation_date%TYPE,

53: p_invoice_date IN ap_invoices.invoice_date%TYPE ,
54: p_invoice_amount IN ap_invoices.invoice_amount%TYPE ,
55: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE ,
56: p_check_id IN ap_checks.check_id%TYPE,
57: p_check_date IN ap_checks.creation_date%TYPE,
58: p_amount IN ap_checks.amount%TYPE,
59: p_treasury_pay_number IN ap_checks.treasury_pay_number%TYPE,
60: p_treasury_pay_date IN ap_checks.treasury_pay_date%TYPE,
61: p_valid_req_supplier IN NUMBER,

Line 58: p_amount IN ap_checks.amount%TYPE,

54: p_invoice_amount IN ap_invoices.invoice_amount%TYPE ,
55: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE ,
56: p_check_id IN ap_checks.check_id%TYPE,
57: p_check_date IN ap_checks.creation_date%TYPE,
58: p_amount IN ap_checks.amount%TYPE,
59: p_treasury_pay_number IN ap_checks.treasury_pay_number%TYPE,
60: p_treasury_pay_date IN ap_checks.treasury_pay_date%TYPE,
61: p_valid_req_supplier IN NUMBER,
62: p_supplier_name IN po_vendors.vendor_name%TYPE,

Line 59: p_treasury_pay_number IN ap_checks.treasury_pay_number%TYPE,

55: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE ,
56: p_check_id IN ap_checks.check_id%TYPE,
57: p_check_date IN ap_checks.creation_date%TYPE,
58: p_amount IN ap_checks.amount%TYPE,
59: p_treasury_pay_number IN ap_checks.treasury_pay_number%TYPE,
60: p_treasury_pay_date IN ap_checks.treasury_pay_date%TYPE,
61: p_valid_req_supplier IN NUMBER,
62: p_supplier_name IN po_vendors.vendor_name%TYPE,
63: p_supplier_site IN po_vendor_sites.vendor_site_code%TYPE,

Line 60: p_treasury_pay_date IN ap_checks.treasury_pay_date%TYPE,

56: p_check_id IN ap_checks.check_id%TYPE,
57: p_check_date IN ap_checks.creation_date%TYPE,
58: p_amount IN ap_checks.amount%TYPE,
59: p_treasury_pay_number IN ap_checks.treasury_pay_number%TYPE,
60: p_treasury_pay_date IN ap_checks.treasury_pay_date%TYPE,
61: p_valid_req_supplier IN NUMBER,
62: p_supplier_name IN po_vendors.vendor_name%TYPE,
63: p_supplier_site IN po_vendor_sites.vendor_site_code%TYPE,
64: p_result IN VARCHAR2,

Line 297: AND EXISTS (SELECT 1 FROM ap_checks ac

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)
300: AND TRUNC(ac.check_date) = NVL(vp_check_date,TRUNC(ac.check_date))
301: AND ac.amount = nvl(vp_amount,ac.amount)

Line 312: AND EXISTS (SELECT 1 FROM ap_checks ac

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)
315: AND TRUNC(ac.check_date) = NVL(vp_check_date,TRUNC(ac.check_date))
316: AND ac.amount = nvl(vp_amount,ac.amount)

Line 338: AND EXISTS (SELECT 1 FROM ap_checks ac

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)
341: AND TRUNC(ac.check_date) = NVL(vp_check_date,TRUNC(ac.check_date))
342: AND ac.amount = nvl(vp_amount,ac.amount)

Line 353: AND EXISTS (SELECT 1 FROM ap_checks ac

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)
356: AND TRUNC(ac.check_date) = NVL(vp_check_date,TRUNC(ac.check_date))
357: AND ac.amount = nvl(vp_amount,ac.amount)

Line 667: AND EXISTS (SELECT 1 FROM ap_checks ac

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
670: AND ac.vendor_site_id = vp_vendor_site_id
671: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 685: AND EXISTS (SELECT 1 FROM ap_checks ac

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
688: AND ac.vendor_site_id = vp_vendor_site_id
689: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 709: AND EXISTS (SELECT 1 FROM ap_checks ac

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)
712: AND ac.check_date = NVL(vp_check_date,ac.check_date)
713: AND ac.amount = nvl(vp_amount,ac.amount)

Line 725: AND EXISTS (SELECT 1 FROM ap_checks ac

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
728: AND ac.vendor_site_id = vp_vendor_site_id
729: AND ac.check_id = NVL(vp_check_id,ac.check_id)

Line 972: AND EXISTS (SELECT 1 FROM ap_checks ac

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)
975: AND TRUNC(ac.check_date) = NVL(vp_check_date,TRUNC(ac.check_date))
976: AND ac.amount = nvl(vp_amount,ac.amount)

Line 995: AND EXISTS (SELECT 1 FROM ap_checks ac

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)
998: AND TRUNC(ac.check_date) = NVL(vp_check_date,TRUNC(ac.check_date))
999: AND ac.amount = nvl(vp_amount,ac.amount)

Line 1281: AND EXISTS (SELECT 1 FROM ap_checks ac

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)
1284: AND TRUNC(ac.check_date) = NVL(vp_check_date,TRUNC(ac.check_date))
1285: AND ac.amount = nvl(vp_amount,ac.amount)

Line 1298: AND EXISTS (SELECT 1 FROM ap_checks ac

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)
1301: AND TRUNC(ac.check_date) = NVL(vp_check_date,TRUNC(ac.check_date))
1302: AND ac.amount = nvl(vp_amount,ac.amount)

Line 1409: SELECT check_id FROM ap_checks ac

1405: l_module_name VARCHAR2(200) := g_module_name || 'pay_master';
1406: l_errbuf VARCHAR2(1024);
1407:
1408: CURSOR req_cur IS
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

Line 1443: SELECT check_id FROM ap_checks ac

1439: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id )
1440: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date)))))))))))
1441:
1442: UNION
1443: SELECT check_id FROM ap_checks ac
1444: WHERE vendor_id = vp_vendor_id
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

Line 1480: SELECT check_id FROM ap_checks ac

1476: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date)))))))))));
1477: req_rec req_cur%ROWTYPE;
1478:
1479: CURSOR po_cur IS
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

Line 1502: SELECT check_id FROM ap_checks ac

1498: AND ph.po_header_id = NVL(vp_po_header_id,ph.po_header_id )
1499: AND TRUNC(ph.creation_date) = NVL( vp_po_date,TRUNC(ph.creation_date)))))))
1500:
1501: UNION
1502: SELECT check_id FROM ap_checks ac
1503: WHERE vendor_id = vp_vendor_id
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

Line 1528: SELECT check_id FROM ap_checks ac

1524:
1525: po_rec po_cur%ROWTYPE;
1526:
1527: CURSOR rec_cur IS
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

Line 1544: SELECT check_id FROM ap_checks ac

1540: WHERE rt.shipment_header_id = rsh.shipment_header_id
1541: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )
1542: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date)))))))
1543: UNION
1544: SELECT check_id FROM ap_checks ac
1545: WHERE vendor_id = vp_vendor_id
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

Line 1566: SELECT check_id FROM ap_checks ac

1562: rec_rec rec_cur%ROWTYPE;
1563:
1564:
1565: CURSOR inv_cur IS
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

Line 1581: SELECT check_id FROM ap_checks ac

1577: AND ai.invoice_id = NVL(vp_invoice_id,ai.invoice_id )
1578: AND ai.invoice_amount = NVL(vp_invoice_amount,ai.invoice_amount)
1579: AND TRUNC(ai.invoice_date) = NVL( vp_invoice_date,TRUNC(ai.invoice_date)))))
1580: UNION
1581: SELECT check_id FROM ap_checks ac
1582: WHERE vendor_id = vp_vendor_id
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

Line 1600: SELECT check_id FROM ap_checks ac

1596: AND TRUNC(ai.invoice_date) = NVL( TRUNC(vp_invoice_date),TRUNC(ai.invoice_date)))));
1597: inv_rec inv_cur%ROWTYPE;
1598:
1599: CURSOR pay_cur IS
1600: SELECT check_id FROM ap_checks ac
1601: WHERE vendor_id = vp_vendor_id
1602: AND vendor_site_id = vp_vendor_site_id
1603: AND ac.check_id = NVL(vp_check_id,ac.check_id)
1604: AND ac.check_date = NVL(vp_check_date,ac.check_date)