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 RCV_TRANSACTIONS

Line 190: AND EXISTS (SELECT 1 FROM rcv_transactions rt

186: WHERE ph.po_header_id = pll.po_header_id
187: AND vendor_id = vp_vendor_id
188: AND vendor_site_id = vp_vendor_site_id
189: AND NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
190: AND EXISTS (SELECT 1 FROM rcv_transactions rt
191: WHERE rt.po_header_id = ph.po_header_id
192: AND rt.po_line_id = pll.po_line_id
193: AND rt.po_line_location_id = pll.line_location_id
194: AND EXISTS (SELECT 1 from rcv_shipment_headers rsh

Line 209: AND EXISTS (SELECT 1 FROM rcv_transactions rt

205: WHERE fst.po_header_id = ph.po_header_id
206: AND fst.po_line_id = pll.po_line_id
207: AND fst.po_line_location_id = pll.line_location_id
208: AND fst.session_id = vp_session_id)
209: AND EXISTS (SELECT 1 FROM rcv_transactions rt
210: WHERE rt.po_header_id = ph.po_header_id
211: AND rt.po_line_id = pll.po_line_id
212: AND rt.po_line_location_id = pll.line_location_id
213: AND EXISTS (SELECT 1 from rcv_shipment_headers rsh

Line 236: OR EXISTS (SELECT 1 FROM rcv_transactions rt

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)
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

Line 268: OR EXISTS (SELECT 1 FROM rcv_transactions rt

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)
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

Line 305: OR EXISTS (SELECT 1 from rcv_transactions rt

301: AND ac.amount = nvl(vp_amount,ac.amount)
302: AND NVL(ac.treasury_pay_number,-1) =NVL(vp_treasury_pay_number,NVL(ac.treasury_pay_number,-1))
303: AND (TRUNC(ac.treasury_pay_date) = TRUNC(vp_treasury_pay_date)
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

Line 346: OR EXISTS (SELECT 1 from rcv_transactions rt

342: AND ac.amount = nvl(vp_amount,ac.amount)
343: AND NVL(ac.treasury_pay_number,-1) =NVL(vp_treasury_pay_number,NVL(ac.treasury_pay_number,-1))
344: AND (TRUNC(ac.treasury_pay_date) = TRUNC(vp_treasury_pay_date)
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

Line 535: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph

531: SELECT requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl
532: WHERE NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
533: AND (EXISTS (SELECT 1 FROM po_req_distributions prd
534: WHERE prd.requisition_line_id = prl.requisition_line_id
535: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph
536: WHERE rt.po_header_id = ph.po_header_id
537: AND rt.req_distribution_id = prd.distribution_id
538: AND ph.vendor_site_id = vp_vendor_site_id
539: AND EXISTS (SELECT 1 FROM rcv_shipment_headers rsh

Line 546: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph

542: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id)
543: AND TRUNC(rsh.creation_date) = NVL(vp_rec_date,TRUNC(rsh.creation_date)))))
544: OR EXISTS (SELECT 1 FROM po_distributions pd
545: WHERE pd.line_location_id = prl.line_location_id
546: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph
547: WHERE rt.po_header_id = ph.po_header_id
548: AND rt.po_line_location_id = pd.line_location_id
549: AND ph.vendor_site_id = vp_vendor_site_id
550: AND EXISTS (SELECT 1 FROM rcv_shipment_headers rsh

Line 564: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph

560: AND requisition_line_id = prl.requisition_line_id
561: AND session_id = vp_session_id)
562: AND (EXISTS (SELECT 1 FROM po_req_distributions prd
563: WHERE prd.requisition_line_id = prl.requisition_line_id
564: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph
565: WHERE rt.po_header_id = ph.po_header_id
566: AND rt.req_distribution_id = prd.distribution_id
567: AND ph.vendor_site_id = vp_vendor_site_id
568: AND EXISTS (SELECT 1 FROM rcv_shipment_headers rsh

Line 575: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph

571: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id)
572: AND TRUNC(rsh.creation_date) = NVL(vp_rec_date,TRUNC(rsh.creation_date)))))
573: OR EXISTS (SELECT 1 FROM po_distributions pd
574: WHERE pd.line_location_id = prl.line_location_id
575: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph
576: WHERE rt.po_header_id = ph.po_header_id
577: AND rt.po_line_location_id = pd.line_location_id
578: AND ph.vendor_site_id = vp_vendor_site_id
579: AND EXISTS (SELECT 1 FROM rcv_shipment_headers rsh

Line 608: AND EXISTS ( SELECT 1 FROM rcv_transactions rt

604: AND ai.invoice_type_lookup_code = nvl(vp_invoice_type,invoice_type_lookup_code)
605: AND ai.invoice_amount = nvl(vp_invoice_amount,invoice_amount)))
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

Line 642: AND EXISTS (SELECT 1 FROM rcv_transactions rt

638: AND ai.invoice_type_lookup_code = NVL(vp_invoice_type,invoice_type_lookup_code)
639: AND ai.invoice_amount = nvl(vp_invoice_amount,invoice_amount)))
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

Line 679: AND EXISTS (SELECT 1 FROM rcv_transactions rt

675: AND (TRUNC(ac.treasury_pay_date) = TRUNC(vp_treasury_pay_date)
676: OR vp_treasury_pay_date IS NULL))))
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

Line 719: AND EXISTS (SELECT 1 FROM rcv_transactions rt

715: AND (TRUNC(ac.treasury_pay_date) = TRUNC(vp_treasury_pay_date)
716: OR vp_treasury_pay_date IS NULL))))
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

Line 848: WHERE EXISTS (SELECT 1 FROM rcv_transactions rt

844: rec_rec rec_cur%ROWTYPE;
845:
846: CURSOR po_cur IS
847: SELECT rsh.shipment_header_id FROM rcv_shipment_headers rsh
848: WHERE EXISTS (SELECT 1 FROM rcv_transactions rt
849: WHERE rt.shipment_header_id = rsh.shipment_header_id
850: AND EXISTS (select 1 FROM po_headers ph
851: WHERE ph.po_header_id = rt.po_header_id
852: AND vendor_id = vp_vendor_id

Line 860: WHERE EXISTS (SELECT 1 FROM rcv_transactions rt

856: AND ph.agent_id = NVL(vp_buyer,ph.agent_id)))
857: AND NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
858: UNION
859: SELECT shipment_header_id FROM rcv_shipment_headers rsh
860: WHERE EXISTS (SELECT 1 FROM rcv_transactions rt
861: WHERE rt.shipment_header_id = rsh.shipment_header_id
862: AND EXISTS (select 1 FROM po_headers ph
863: WHERE ph.po_header_id = rt.po_header_id
864: AND vendor_id = vp_vendor_id

Line 877: AND EXISTS(SELECT 1 FROM rcv_transactions rt,po_headers ph

873: CURSOR req_cur IS
874: SELECT rsh.shipment_header_id FROM rcv_shipment_headers rsh
875: WHERE rsh.vendor_id = vp_vendor_id
876: AND NOT EXISTS (SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
877: AND EXISTS(SELECT 1 FROM rcv_transactions rt,po_headers ph
878: WHERE ph.po_header_id = rt.po_header_id
879: AND rt.shipment_header_id = rsh.shipment_header_id
880: AND ph.vendor_site_id = vp_vendor_site_id
881: AND (EXISTS (SELECT 1 FROM po_req_distributions prd

Line 900: AND EXISTS(SELECT 1 FROM rcv_transactions rt,po_headers ph

896: WHERE rsh.vendor_id = vp_vendor_id
897: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp fdct
898: WHERE fdct.shipment_header_id = rsh.shipment_header_id
899: AND fdct.session_id = vp_session_id)
900: AND EXISTS(SELECT 1 FROM rcv_transactions rt,po_headers ph
901: WHERE rt.po_header_id = ph.po_header_id
902: AND rt.shipment_header_id = rsh.shipment_header_id
903: AND ph.vendor_site_id = vp_vendor_site_id
904: AND (EXISTS (SELECT 1 FROM po_req_distributions prd

Line 925: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph

921: CURSOR inv_cur IS
922: SELECT shipment_header_id FROM rcv_shipment_headers rsh
923: WHERE vendor_id = vp_vendor_id
924: AND NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
925: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph
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

Line 944: AND EXISTS (SELECT 1 FROM rcv_transactions rt ,po_headers ph

940: WHERE vendor_id = vp_vendor_id
941: AND EXISTS(SELECT 1 FROM fv_doc_cr_temp
942: WHERE shipment_header_id = rsh.shipment_header_id
943: AND session_id = vp_session_id)
944: AND EXISTS (SELECT 1 FROM rcv_transactions rt ,po_headers ph
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

Line 963: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph

959: CURSOR pay_cur IS
960: SELECT shipment_header_id FROM rcv_shipment_headers rsh
961: WHERE vendor_id = vp_vendor_id
962: AND NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
963: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph
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

Line 985: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph

981: WHERE vendor_id = vp_vendor_id
982: AND EXISTS(SELECT 1 FROM fv_doc_cr_temp
983: WHERE shipment_header_id = rsh.shipment_header_id
984: AND session_id = vp_session_id)
985: AND EXISTS (SELECT 1 FROM rcv_transactions rt,po_headers ph
986: WHERE rt.po_header_id = ph.po_header_id
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

Line 1122: OR EXISTS (SELECT 1 FROM rcv_transactions rt

1118: AND EXISTS (SELECT 1 FROM po_requisition_headers prh
1119: WHERE prh.requisition_header_id = prl.requisition_header_id
1120: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id )
1121: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))
1122: OR EXISTS (SELECT 1 FROM rcv_transactions rt
1123: WHERE rt.transaction_id = aid.rcv_transaction_id
1124: AND EXISTS (SELECT 1 FROM po_line_locations pll
1125: WHERE rt.po_line_location_id = pll.line_location_id
1126: AND EXISTS(SELECT 1 FROM po_distributions pd

Line 1155: OR EXISTS (SELECT 1 FROM rcv_transactions rt

1151: AND EXISTS (SELECT 1 FROM po_requisition_headers prh
1152: WHERE prh.requisition_header_id = prl.requisition_header_id
1153: AND prh.requisition_header_id =NVL(vp_requisition_header_id,prh.requisition_header_id )
1154: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))
1155: OR EXISTS (SELECT 1 FROM rcv_transactions rt
1156: WHERE rt.transaction_id = aid.rcv_transaction_id
1157: AND EXISTS (SELECT 1 FROM po_line_locations pll
1158: WHERE rt.po_line_location_id = pll.line_location_id
1159: AND EXISTS(SELECT 1 FROM po_distributions pd

Line 1185: OR EXISTS (SELECT 1 FROM rcv_transactions rt

1181: AND EXISTS(SELECT 1 FROM po_headers ph
1182: WHERE ph.po_header_id = pd.po_header_id
1183: AND ph.po_header_id = NVL(vp_po_header_id,ph.po_header_id )
1184: AND TRUNC(ph.creation_date) = NVL( vp_po_date,TRUNC(ph.creation_date))))
1185: OR EXISTS (SELECT 1 FROM rcv_transactions rt
1186: WHERE rt.transaction_id = aid.rcv_transaction_id
1187: AND EXISTS(SELECT 1 FROM po_headers ph
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 )

Line 1206: OR EXISTS (SELECT 1 FROM rcv_transactions rt

1202: AND EXISTS(SELECT 1 FROM po_headers ph
1203: WHERE ph.po_header_id = pd.po_header_id
1204: AND ph.po_header_id = NVL(vp_po_header_id,ph.po_header_id )
1205: AND TRUNC(ph.creation_date) = NVL( vp_po_date,TRUNC(ph.creation_date))))
1206: OR EXISTS (SELECT 1 FROM rcv_transactions rt
1207: WHERE rt.transaction_id = aid.rcv_transaction_id
1208: AND EXISTS(SELECT 1 FROM po_headers ph
1209: WHERE ph.po_header_id = rt.po_header_id
1210: AND ph.po_header_id = NVL(vp_po_header_id,rt.po_header_id )

Line 1225: AND (EXISTS (SELECT 1 FROM rcv_transactions rt

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
1228: WHERE rt.shipment_header_id = rsh.shipment_header_id
1229: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )

Line 1247: AND (EXISTS (SELECT 1 FROM rcv_transactions rt

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
1250: WHERE rt.shipment_header_id = rsh.shipment_header_id
1251: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )

Line 1427: OR EXISTS (SELECT 1 FROM rcv_transactions rt

1423: AND EXISTS (SELECT 1 FROM po_requisition_headers prh
1424: WHERE prh.requisition_header_id = prl.requisition_header_id
1425: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id )
1426: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))
1427: OR EXISTS (SELECT 1 FROM rcv_transactions rt
1428: WHERE rt.transaction_id = aid.rcv_transaction_id
1429: AND EXISTS (SELECT 1 FROM po_line_locations pll
1430: WHERE pll.line_location_id = rt.po_line_location_id
1431: AND EXISTS (SELECT 1 FROM po_distributions pd

Line 1463: OR EXISTS (SELECT 1 FROM rcv_transactions rt

1459: AND EXISTS (SELECT 1 FROM po_requisition_headers prh
1460: WHERE prh.requisition_header_id = prl.requisition_header_id
1461: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id )
1462: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))
1463: OR EXISTS (SELECT 1 FROM rcv_transactions rt
1464: WHERE rt.transaction_id = aid.rcv_transaction_id
1465: AND EXISTS (SELECT 1 FROM po_line_locations pll
1466: WHERE pll.line_location_id = rt.po_line_location_id
1467: AND EXISTS (SELECT 1 FROM po_distributions pd

Line 1494: OR EXISTS (SELECT 1 FROM rcv_transactions rt

1490: AND EXISTS(SELECT 1 FROM po_headers ph
1491: WHERE ph.po_header_id = pd.po_header_id
1492: AND ph.po_header_id = NVL(vp_po_header_id,ph.po_header_id )
1493: AND TRUNC(ph.creation_date) = NVL( vp_po_date,TRUNC(ph.creation_date))))
1494: OR EXISTS (SELECT 1 FROM rcv_transactions rt
1495: WHERE rt.transaction_id = aid.rcv_transaction_id
1496: AND EXISTS(SELECT 1 FROM po_headers ph
1497: WHERE ph.po_header_id = rt.po_header_id
1498: AND ph.po_header_id = NVL(vp_po_header_id,ph.po_header_id )

Line 1518: OR EXISTS (SELECT 1 FROM rcv_transactions rt

1514: AND EXISTS(SELECT 1 FROM po_headers ph
1515: WHERE ph.po_header_id = pd.po_header_id
1516: AND ph.po_header_id = NVL(vp_po_header_id,ph.po_header_id )
1517: AND TRUNC(ph.creation_date) = NVL( vp_po_date,TRUNC(ph.creation_date))))
1518: OR EXISTS (SELECT 1 FROM rcv_transactions rt
1519: WHERE rt.transaction_id = aid.rcv_transaction_id
1520: AND EXISTS(SELECT 1 FROM po_headers ph
1521: WHERE ph.po_header_id = rt.po_header_id
1522: AND ph.po_header_id = NVL(vp_po_header_id,ph.po_header_id )

Line 1537: AND EXISTS( SELECT 1 FROM rcv_transactions rt

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
1539: AND EXISTS(SELECT 1 FROM rcv_shipment_headers rsh
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 )

Line 1555: AND EXISTS( SELECT 1 FROM rcv_transactions rt

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
1557: AND EXISTS(SELECT 1 FROM rcv_shipment_headers rsh
1558: WHERE rt.shipment_header_id = rsh.shipment_header_id
1559: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )