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 PO_DISTRIBUTIONS

Line 225: AND (EXISTS (SELECT 1 FROM po_distributions pd

221: WHERE ph.po_header_id = pll.po_header_id
222: AND vendor_id = vp_vendor_id
223: AND vendor_site_id = vp_vendor_site_id
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

Line 257: AND (EXISTS (SELECT 1 FROM po_distributions pd

253: WHERE fst.po_header_id = ph.po_header_id
254: AND fst.po_line_id = pll.po_line_id
255: AND fst.po_line_location_id = pll.line_location_id
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

Line 290: AND EXISTS (SELECT 1 from po_distributions pd

286: AND vendor_id = vp_vendor_id
287: AND vendor_site_id = vp_vendor_site_id
288: AND NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp
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

Line 331: AND EXISTS (SELECT 1 from po_distributions pd

327: AND fst.po_line_location_id = pll.line_location_id
328: AND fst.session_id = vp_session_id)
329: AND vendor_id = vp_vendor_id
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

Line 544: OR EXISTS (SELECT 1 FROM po_distributions pd

540: WHERE rsh.vendor_id = vp_vendor_id
541: AND rsh.shipment_header_id = rt.shipment_header_id
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

Line 573: OR EXISTS (SELECT 1 FROM po_distributions pd

569: WHERE rsh.vendor_id = vp_vendor_id
570: AND rsh.shipment_header_id = rt.shipment_header_id
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

Line 594: AND EXISTS (SELECT 1 FROM po_distributions pd

590: SELECT prl.requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl
591: WHERE NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
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

Line 628: AND EXISTS (SELECT 1 FROM po_distributions pd

624: AND requisition_line_id = prl.requisition_line_id
625: AND session_id = vp_session_id)
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

Line 661: AND EXISTS (SELECT 1 FROM po_distributions pd

657: CURSOR pay_cur IS
658: SELECT prl.requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl
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

Line 703: AND EXISTS (SELECT 1 FROM po_distributions pd

699: AND requisition_line_id = prl.requisition_line_id
700: AND session_id = vp_session_id)
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

Line 929: AND EXISTS (SELECT 1 FROM po_distributions pd WHERE pd.line_location_id = rt.po_line_location_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
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

Line 948: AND EXISTS (SELECT 1 FROM po_distributions pd WHERE pd.line_location_id = rt.po_line_location_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
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

Line 967: AND EXISTS (SELECT 1 FROM po_distributions pd WHERE pd.line_location_id = rt.po_line_location_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
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

Line 989: AND EXISTS (SELECT 1 FROM po_distributions pd

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

Line 1112: AND EXISTS (SELECT 1 FROM po_distributions pd

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
1115: WHERE prd.distribution_id = pd.req_distribution_id
1116: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

Line 1126: AND EXISTS(SELECT 1 FROM po_distributions pd

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
1127: WHERE pd.line_location_id = pll.line_location_id
1128: AND EXISTS (SELECT 1 FROM po_req_distributions prd
1129: WHERE prd.distribution_id = pd.req_distribution_id
1130: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

Line 1145: AND EXISTS (SELECT 1 FROM po_distributions pd

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
1148: WHERE prd.distribution_id = pd.req_distribution_id
1149: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

Line 1159: AND EXISTS(SELECT 1 FROM po_distributions pd

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
1160: WHERE pd.line_location_id = pll.line_location_id
1161: AND EXISTS (SELECT 1 FROM po_req_distributions prd
1162: WHERE prd.distribution_id = pd.req_distribution_id
1163: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

Line 1179: AND EXISTS (SELECT 1 FROM po_distributions pd

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

Line 1200: AND EXISTS (SELECT 1 FROM po_distributions pd

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

Line 1231: OR EXISTS (SELECT 1 FROM po_distributions pd

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 )
1230: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))
1231: OR EXISTS (SELECT 1 FROM po_distributions pd
1232: WHERE pd.po_distribution_id = aid.po_distribution_id
1233: AND EXISTS(SELECT 1 FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh
1234: WHERE rsl.po_line_location_id = pd.line_location_id
1235: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 1253: OR EXISTS (SELECT 1 FROM po_distributions pd

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 )
1252: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))
1253: OR EXISTS (SELECT 1 FROM po_distributions pd
1254: WHERE pd.po_distribution_id = aid.po_distribution_id
1255: AND EXISTS(SELECT 1 FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh
1256: WHERE rsl.po_line_location_id = pd.line_location_id
1257: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 1417: AND (EXISTS (SELECT 1 FROM po_distributions pd

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
1420: WHERE prd.distribution_id = pd.req_distribution_id
1421: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

Line 1431: AND EXISTS (SELECT 1 FROM po_distributions pd

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
1432: WHERE pd.line_location_id = pll.line_location_id
1433: AND EXISTS(SELECT 1 FROM po_req_distributions prd
1434: WHERE prd.distribution_id = pd.req_distribution_id
1435: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

Line 1453: AND (EXISTS (SELECT 1 FROM po_distributions pd

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
1456: WHERE prd.distribution_id = pd.req_distribution_id
1457: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

Line 1467: AND EXISTS (SELECT 1 FROM po_distributions pd

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
1468: WHERE pd.line_location_id = pll.line_location_id
1469: AND EXISTS(SELECT 1 FROM po_req_distributions prd
1470: WHERE prd.distribution_id = pd.req_distribution_id
1471: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

Line 1488: AND (EXISTS (SELECT 1 FROM po_distributions pd

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

Line 1512: AND (EXISTS (SELECT 1 FROM po_distributions pd

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

Line 1536: AND EXISTS (SELECT 1 FROM po_distributions pd WHERE pd.po_distribution_id = aid.po_distribution_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
1539: AND EXISTS(SELECT 1 FROM rcv_shipment_headers rsh
1540: WHERE rt.shipment_header_id = rsh.shipment_header_id

Line 1554: AND EXISTS (SELECT 1 FROM po_distributions pd WHERE pd.po_distribution_id = aid.po_distribution_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
1557: AND EXISTS(SELECT 1 FROM rcv_shipment_headers rsh
1558: WHERE rt.shipment_header_id = rsh.shipment_header_id