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_INVOICES

Line 15: vp_invoice_id ap_invoices.invoice_id%TYPE;

11: vp_req_date po_requisition_headers.creation_date%TYPE;
12: vp_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
13: vp_rec_date rcv_shipment_headers.creation_date%TYPE;
14: vp_buyer po_headers.agent_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;

Line 16: vp_invoice_date ap_invoices.invoice_date%TYPE;

12: vp_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE;
13: vp_rec_date rcv_shipment_headers.creation_date%TYPE;
14: vp_buyer po_headers.agent_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;

Line 17: vp_invoice_amount ap_invoices.invoice_amount%TYPE;

13: vp_rec_date rcv_shipment_headers.creation_date%TYPE;
14: vp_buyer po_headers.agent_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;

Line 18: vp_invoice_type ap_invoices.invoice_type_lookup_code%TYPE;

14: vp_buyer po_headers.agent_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;

Line 52: p_invoice_id IN ap_invoices.invoice_id%TYPE,

48: p_req_date IN po_requisition_headers.creation_date%TYPE,
49: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
50: p_receipt_date IN rcv_shipment_headers.creation_date%TYPE,
51: p_buyer IN po_headers.agent_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,

Line 53: p_invoice_date IN ap_invoices.invoice_date%TYPE ,

49: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
50: p_receipt_date IN rcv_shipment_headers.creation_date%TYPE,
51: p_buyer IN po_headers.agent_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,

Line 54: p_invoice_amount IN ap_invoices.invoice_amount%TYPE ,

50: p_receipt_date IN rcv_shipment_headers.creation_date%TYPE,
51: p_buyer IN po_headers.agent_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,

Line 55: p_invoice_type IN ap_invoices.invoice_type_lookup_code%TYPE ,

51: p_buyer IN po_headers.agent_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,

Line 230: AND EXISTS (SELECT 1 FROM ap_invoices ap

226: WHERE pd.po_header_id = ph.po_header_id
227: AND pd.line_location_id = pll.line_location_id
228: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia
229: WHERE ia.po_distribution_id= pd.po_distribution_id
230: AND EXISTS (SELECT 1 FROM ap_invoices ap
231: WHERE invoice_id = ia.invoice_id
232: AND invoice_id = NVL(vp_invoice_id,invoice_id)
233: AND TRUNC(ap.invoice_date) = NVL(vp_invoice_date,TRUNC(ap.invoice_date))
234: AND invoice_type_lookup_code = NVL(vp_invoice_type,invoice_type_lookup_code)

Line 241: AND EXISTS (SELECT 1 FROM ap_invoices ap

237: WHERE rt.po_header_id = ph.po_header_id
238: AND rt.po_line_location_id = pll.line_location_id
239: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia
240: WHERE ia.rcv_transaction_id= rt.transaction_id
241: AND EXISTS (SELECT 1 FROM ap_invoices ap
242: WHERE invoice_id = ia.invoice_id
243: AND invoice_id = NVL(vp_invoice_id,invoice_id)
244: AND TRUNC(ap.invoice_date) = NVL(vp_invoice_date,TRUNC(ap.invoice_date))
245: AND invoice_type_lookup_code = nvl(vp_invoice_type,invoice_type_lookup_code)

Line 262: AND EXISTS (SELECT 1 FROM ap_invoices ap

258: WHERE pd.po_header_id = ph.po_header_id
259: AND pd.line_location_id = pll.line_location_id
260: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia
261: WHERE ia.po_distribution_id= pd.po_distribution_id
262: AND EXISTS (SELECT 1 FROM ap_invoices ap
263: WHERE invoice_id = ia.invoice_id
264: AND invoice_id = NVL(vp_invoice_id,invoice_id)
265: AND TRUNC(ap.invoice_date) =NVL(vp_invoice_date,TRUNC(ap.invoice_date))
266: AND invoice_type_lookup_code =NVL(vp_invoice_type,invoice_type_lookup_code)

Line 273: AND EXISTS (SELECT 1 FROM ap_invoices ap

269: WHERE rt.po_header_id = ph.po_header_id
270: AND rt.po_line_location_id = pll.line_location_id
271: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia
272: WHERE ia.rcv_transaction_id= rt.transaction_id
273: AND EXISTS (SELECT 1 FROM ap_invoices ap
274: WHERE invoice_id = ia.invoice_id
275: AND invoice_id = NVL(vp_invoice_id,invoice_id)
276: AND TRUNC(ap.invoice_date) = nvl(vp_invoice_date,TRUNC(ap.invoice_date))
277: AND invoice_type_lookup_code = nvl(vp_invoice_type,invoice_type_lookup_code)

Line 598: AND EXISTS (SELECT 1 FROM ap_invoices ai

594: AND EXISTS (SELECT 1 FROM po_distributions pd
595: WHERE pd.req_distribution_id = prd.distribution_id
596: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid
597: WHERE aid.po_distribution_id= pd.po_distribution_id
598: AND EXISTS (SELECT 1 FROM ap_invoices ai
599: WHERE ai.invoice_id = aid.invoice_id
600: AND ai.vendor_id = vp_vendor_id
601: AND ai.vendor_site_id = vp_vendor_site_id
602: AND ai.invoice_id = NVL(vp_invoice_id,invoice_id)

Line 612: AND EXISTS (SELECT 1 FROM ap_invoices ai

608: AND EXISTS ( SELECT 1 FROM rcv_transactions rt
609: WHERE rt.po_line_location_id = pll.line_location_id
610: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
611: WHERE aid.rcv_transaction_id = rt.transaction_id
612: AND EXISTS (SELECT 1 FROM ap_invoices ai
613: WHERE ai.invoice_id = aid.invoice_id
614: AND ai.vendor_id = vp_vendor_id
615: AND ai.vendor_site_id = vp_vendor_site_id
616: AND ai.invoice_id = NVL(vp_invoice_id,invoice_id)

Line 632: AND EXISTS (SELECT 1 FROM ap_invoices ai

628: AND EXISTS (SELECT 1 FROM po_distributions pd
629: WHERE pd.req_distribution_id = prd.distribution_id
630: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid
631: WHERE aid.po_distribution_id= pd.po_distribution_id
632: AND EXISTS (SELECT 1 FROM ap_invoices ai
633: WHERE ai.invoice_id = aid.invoice_id
634: AND ai.vendor_id = vp_vendor_id
635: AND ai.vendor_site_id = vp_vendor_site_id
636: AND ai.invoice_id = NVL(vp_invoice_id,invoice_id)

Line 646: AND EXISTS (SELECT 1 FROM ap_invoices ai

642: AND EXISTS (SELECT 1 FROM rcv_transactions rt
643: WHERE rt.po_line_location_id = pll.line_location_id
644: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
645: WHERE aid.rcv_transaction_id = rt.transaction_id
646: AND EXISTS (SELECT 1 FROM ap_invoices ai
647: WHERE ai.invoice_id = aid.invoice_id
648: AND ai.vendor_id = vp_vendor_id
649: AND ai.vendor_site_id = vp_vendor_site_id
650: AND ai.invoice_id = NVL(vp_invoice_id,invoice_id)

Line 932: AND EXISTS (SELECT 1 FROM ap_invoices ap

928: AND ph.vendor_site_id = vp_vendor_site_id
929: AND EXISTS (SELECT 1 FROM po_distributions pd WHERE pd.line_location_id = rt.po_line_location_id
930: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia
931: WHERE ia.po_distribution_id= pd.po_distribution_id
932: AND EXISTS (SELECT 1 FROM ap_invoices ap
933: WHERE invoice_id = ia.invoice_id
934: AND invoice_id = NVL(vp_invoice_id,invoice_id)
935: AND TRUNC(ap.invoice_date) = nvl(vp_invoice_date,TRUNC(ap.invoice_date))
936: AND invoice_type_lookup_code = nvl(vp_invoice_type,invoice_type_lookup_code)

Line 951: AND EXISTS (SELECT 1 FROM ap_invoices ap

947: AND ph.vendor_site_id = vp_vendor_site_id
948: AND EXISTS (SELECT 1 FROM po_distributions pd WHERE pd.line_location_id = rt.po_line_location_id
949: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia
950: WHERE ia.po_distribution_id= pd.po_distribution_id
951: AND EXISTS (SELECT 1 FROM ap_invoices ap
952: WHERE invoice_id = ia.invoice_id
953: AND invoice_id = NVL(vp_invoice_id,invoice_id)
954: AND TRUNC(ap.invoice_date) = nvl(vp_invoice_date,TRUNC(ap.invoice_date))
955: AND invoice_type_lookup_code = nvl(vp_invoice_type,invoice_type_lookup_code)

Line 1106: SELECT invoice_id FROM ap_invoices ai

1102: l_module_name VARCHAR2(200) := g_module_name || 'inv_master';
1103: l_errbuf VARCHAR2(1024);
1104:
1105: CURSOR req_cur IS
1106: SELECT invoice_id FROM ap_invoices ai
1107: WHERE vendor_id = vp_vendor_id
1108: AND vendor_site_id = vp_vendor_site_id
1109: AND NOT EXISTS (SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
1110: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid

Line 1137: SELECT invoice_id FROM ap_invoices ai

1133: WHERE prh.requisition_header_id = prl.requisition_header_id
1134: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id )
1135: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))))))
1136: UNION
1137: SELECT invoice_id FROM ap_invoices ai
1138: WHERE vendor_id = vp_vendor_id
1139: AND vendor_site_id = vp_vendor_site_id
1140: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp
1141: WHERE invoice_id= ai.invoice_id

Line 1173: SELECT invoice_id FROM ap_invoices ai

1169:
1170: req_rec req_cur%ROWTYPE;
1171:
1172: CURSOR po_cur IS
1173: SELECT invoice_id FROM ap_invoices ai
1174: WHERE vendor_id = vp_vendor_id
1175: AND vendor_site_id = vp_vendor_site_id
1176: AND NOT EXISTS (SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
1177: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

Line 1192: SELECT invoice_id FROM ap_invoices ai

1188: WHERE ph.po_header_id = rt.po_header_id
1189: AND ph.po_header_id = NVL(vp_po_header_id,rt.po_header_id )
1190: AND TRUNC(ph.creation_date) = NVL( vp_po_date,TRUNC(ph.creation_date)))))
1191: UNION
1192: SELECT invoice_id FROM ap_invoices ai
1193: WHERE vendor_id = vp_vendor_id
1194: AND vendor_site_id = vp_vendor_site_id
1195: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp
1196: WHERE invoice_id = ai.invoice_id

Line 1219: SELECT invoice_id FROM ap_invoices ai

1215:
1216: po_rec po_cur%ROWTYPE;
1217:
1218: CURSOR rec_cur IS
1219: SELECT invoice_id FROM ap_invoices ai
1220: WHERE vendor_id = vp_vendor_id
1221: AND vendor_site_id = vp_vendor_site_id
1222: AND NOT EXISTS (SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
1223: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

Line 1239: SELECT invoice_id FROM ap_invoices ai

1235: AND rsl.shipment_header_id = rsh.shipment_header_id
1236: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )
1237: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))))
1238: UNION
1239: SELECT invoice_id FROM ap_invoices ai
1240: WHERE vendor_id = vp_vendor_id
1241: AND vendor_site_id = vp_vendor_site_id
1242: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp
1243: WHERE invoice_id = ai.invoice_id

Line 1265: SELECT invoice_id FROM ap_invoices

1261: rec_rec rec_cur%ROWTYPE;
1262:
1263:
1264: CURSOR inv_cur IS
1265: SELECT invoice_id FROM ap_invoices
1266: WHERE vendor_id = vp_vendor_id
1267: AND vendor_site_id = vp_vendor_site_id
1268: AND invoice_id = NVL(vp_invoice_id,invoice_id)
1269: AND invoice_type_lookup_code = NVL(vp_invoice_type,invoice_type_lookup_code)

Line 1275: SELECT invoice_id FROM ap_invoices ai

1271: AND TRUNC(invoice_date) = NVL(TRUNC(vp_invoice_date), TRUNC(invoice_date)) ;
1272: inv_rec inv_cur%ROWTYPE;
1273:
1274: CURSOR pay_cur IS
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

Line 1290: SELECT invoice_id FROM ap_invoices ai

1286: AND NVL(ac.treasury_pay_number,-1) = nvl(vp_treasury_pay_number,NVL(ac.treasury_pay_number,-1))
1287: AND (TRUNC(ac.treasury_pay_date) = TRUNC(vp_treasury_pay_date) OR vp_treasury_pay_date IS NULL)
1288: ))
1289: UNION
1290: SELECT invoice_id FROM ap_invoices ai
1291: WHERE vendor_id = vp_vendor_id
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

Line 1574: AND EXISTS (SELECT 1 FROM ap_invoices ai

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
1575: WHERE ai.invoice_id = aid.invoice_id
1576: AND invoice_type_lookup_code = NVL(vp_invoice_type,invoice_type_lookup_code)
1577: AND ai.invoice_id = NVL(vp_invoice_id,ai.invoice_id )
1578: AND ai.invoice_amount = NVL(vp_invoice_amount,ai.invoice_amount)

Line 1591: AND EXISTS (SELECT 1 FROM ap_invoices ai

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
1592: WHERE ai.invoice_id = aid.invoice_id
1593: AND invoice_type_lookup_code = NVL(vp_invoice_type,invoice_type_lookup_code)
1594: AND ai.invoice_id = NVL(vp_invoice_id,ai.invoice_id )
1595: AND ai.invoice_amount = NVL(vp_invoice_amount,ai.invoice_amount)