DBA Data[Home] [Help]

APPS.FV_CROSS_DOC_REF dependencies on AP_INVOICE_DISTRIBUTIONS

Line 228: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia

224: AND NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
225: AND (EXISTS (SELECT 1 FROM po_distributions pd
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)

Line 239: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia

235: AND invoice_amount = nvl(vp_invoice_amount,invoice_amount))))
236: OR EXISTS (SELECT 1 FROM rcv_transactions rt
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)

Line 260: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia

256: AND fst.session_id = vp_session_id)
257: AND (EXISTS (SELECT 1 FROM po_distributions pd
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)

Line 271: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia

267: AND invoice_amount = nvl(vp_invoice_amount,invoice_amount))))
268: OR EXISTS (SELECT 1 FROM rcv_transactions rt
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)

Line 293: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid

289: WHERE session_id = vp_session_id)
290: AND EXISTS (SELECT 1 from po_distributions pd
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

Line 308: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

304: OR vp_treasury_pay_date IS NULL)))))
305: OR EXISTS (SELECT 1 from rcv_transactions rt
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

Line 334: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid

330: AND vendor_site_id = vp_vendor_site_id
331: AND EXISTS (SELECT 1 from po_distributions pd
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

Line 349: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

345: OR vp_treasury_pay_date IS NULL)))))
346: OR EXISTS (SELECT 1 from rcv_transactions rt
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

Line 596: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid

592: AND EXISTS (SELECT 1 FROM po_req_distributions prd
593: WHERE prd.requisition_line_id = prl.requisition_line_id
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

Line 610: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

606: OR EXISTS (SELECT 1 FROM po_line_locations pll
607: WHERE pll.line_location_id = pd.line_location_id
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

Line 630: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid

626: AND EXISTS (SELECT 1 FROM po_req_distributions prd
627: WHERE prd.requisition_line_id = prl.requisition_line_id
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

Line 644: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

640: OR EXISTS (SELECT 1 FROM po_line_locations pll
641: WHERE pll.line_location_id = pd.line_location_id
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

Line 663: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid

659: WHERE NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
660: AND EXISTS (SELECT 1 FROM po_req_distributions prd WHERE prd.requisition_line_id = prl.requisition_line_id
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

Line 681: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

677: OR EXISTS (SELECT 1 FROM po_line_locations pll
678: WHERE pll.line_location_id = pd.line_location_id
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

Line 705: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid

701: AND EXISTS (SELECT 1 FROM po_req_distributions prd
702: WHERE prd.requisition_line_id = prl.requisition_line_id
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

Line 721: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

717: OR EXISTS (SELECT 1 FROM po_line_locations pll
718: WHERE pll.line_location_id = pd.line_location_id
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

Line 930: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia

926: WHERE ph.po_header_id = rt.po_header_id
927: AND rt.shipment_header_id = rsh.shipment_header_id
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)

Line 949: AND EXISTS (SELECT 1 FROM ap_invoice_distributions ia

945: WHERE rt.po_header_id = ph.po_header_id
946: AND rt.shipment_header_id = rsh.shipment_header_id
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)

Line 968: AND EXISTS( SELECT 1 FROM ap_invoice_distributions aid

964: WHERE rt.po_header_id = ph.po_header_id
965: AND rt.shipment_header_id = rsh.shipment_header_id
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

Line 991: AND EXISTS( SELECT 1 FROM ap_invoice_distributions aid

987: AND rt.shipment_header_id = rsh.shipment_header_id
988: AND ph.vendor_site_id = vp_vendor_site_id
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

Line 1110: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1111: WHERE aid.invoice_id = ai.invoice_id
1112: AND EXISTS (SELECT 1 FROM po_distributions pd
1113: WHERE pd.po_distribution_id = aid.po_distribution_id
1114: AND EXISTS(SELECT 1 FROM po_req_distributions prd

Line 1143: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1142: AND session_id = vp_session_id)
1143: AND (EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1144: WHERE aid.invoice_id = ai.invoice_id
1145: AND EXISTS (SELECT 1 FROM po_distributions pd
1146: WHERE pd.po_distribution_id = aid.po_distribution_id
1147: AND EXISTS(SELECT 1 FROM po_req_distributions prd

Line 1177: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1178: WHERE aid.invoice_id = ai.invoice_id
1179: AND EXISTS (SELECT 1 FROM po_distributions pd
1180: WHERE pd.po_distribution_id = aid.po_distribution_id
1181: AND EXISTS(SELECT 1 FROM po_headers ph

Line 1198: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1197: AND session_id = vp_session_id)
1198: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1199: WHERE aid.invoice_id = ai.invoice_id
1200: AND EXISTS (SELECT 1 FROM po_distributions pd
1201: WHERE pd.po_distribution_id = aid.po_distribution_id
1202: AND EXISTS(SELECT 1 FROM po_headers ph

Line 1223: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1224: WHERE aid.invoice_id = ai.invoice_id
1225: AND (EXISTS (SELECT 1 FROM rcv_transactions rt
1226: WHERE rt.transaction_id = aid.rcv_transaction_id
1227: AND EXISTS(SELECT 1 FROM rcv_shipment_headers rsh

Line 1245: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1244: AND session_id = vp_session_id)
1245: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid
1246: WHERE aid.invoice_id = ai.invoice_id
1247: AND (EXISTS (SELECT 1 FROM rcv_transactions rt
1248: WHERE rt.transaction_id = aid.rcv_transaction_id
1249: AND EXISTS(SELECT 1 FROM rcv_shipment_headers rsh

Line 1415: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1418: WHERE pd.po_distribution_id = aid.po_distribution_id
1419: AND EXISTS(SELECT 1 FROM po_req_distributions prd

Line 1451: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1454: WHERE pd.po_distribution_id = aid.po_distribution_id
1455: AND EXISTS(SELECT 1 FROM po_req_distributions prd

Line 1486: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1489: WHERE pd.po_distribution_id = aid.po_distribution_id
1490: AND EXISTS(SELECT 1 FROM po_headers ph

Line 1510: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1513: WHERE pd.po_distribution_id = aid.po_distribution_id
1514: AND EXISTS(SELECT 1 FROM po_headers ph

Line 1534: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1537: AND EXISTS( SELECT 1 FROM rcv_transactions rt
1538: WHERE rt.po_line_location_id = pd.line_location_id

Line 1552: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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
1555: AND EXISTS( SELECT 1 FROM rcv_transactions rt
1556: WHERE rt.po_line_location_id = pd.line_location_id

Line 1572: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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

Line 1589: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

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