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_REQ_DISTRIBUTIONS

Line 533: AND (EXISTS (SELECT 1 FROM po_req_distributions prd

529:
530: CURSOR rec_cur IS
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

Line 562: AND (EXISTS (SELECT 1 FROM po_req_distributions prd

558: WHERE EXISTS(SELECT 1 FROM fv_doc_cr_temp
559: WHERE requisition_header_id = prl.requisition_header_id
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

Line 592: AND EXISTS (SELECT 1 FROM po_req_distributions prd

588:
589: CURSOR inv_cur IS
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

Line 626: AND EXISTS (SELECT 1 FROM po_req_distributions prd

622: WHERE EXISTS(SELECT 1 FROM fv_doc_cr_temp
623: WHERE requisition_header_id = prl.requisition_header_id
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

Line 660: AND EXISTS (SELECT 1 FROM po_req_distributions prd WHERE prd.requisition_line_id = prl.requisition_line_id

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

Line 701: AND EXISTS (SELECT 1 FROM po_req_distributions prd

697: WHERE EXISTS(SELECT 1 FROM fv_doc_cr_temp
698: WHERE requisition_header_id = prl.requisition_header_id
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

Line 881: AND (EXISTS (SELECT 1 FROM po_req_distributions prd

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
882: WHERE prd.distribution_id = rt.req_distribution_id
883: AND EXISTS (SELECT 1 FROM po_requisition_lines prl,po_requisition_headers prh
884: WHERE prl.requisition_header_id = prh.requisition_header_id
885: AND prl.requisition_line_id = prd.requisition_line_id

Line 904: AND (EXISTS (SELECT 1 FROM po_req_distributions prd

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
905: WHERE prd.distribution_id = rt.req_distribution_id
906: AND EXISTS (SELECT 1 FROM po_requisition_lines prl ,po_requisition_headers prh
907: WHERE prl.requisition_header_id = prh.requisition_header_id
908: AND prl.requisition_line_id = prd.requisition_line_id

Line 1114: AND EXISTS(SELECT 1 FROM po_req_distributions prd

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
1117: WHERE prl.requisition_line_id = prd.requisition_line_id
1118: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

Line 1128: AND EXISTS (SELECT 1 FROM po_req_distributions prd

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
1131: WHERE prl.requisition_line_id = prd.requisition_line_id
1132: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

Line 1147: AND EXISTS(SELECT 1 FROM po_req_distributions prd

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
1150: WHERE prl.requisition_line_id = prd.requisition_line_id
1151: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

Line 1161: AND EXISTS (SELECT 1 FROM po_req_distributions prd

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
1164: WHERE prl.requisition_line_id = prd.requisition_line_id
1165: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

Line 1419: AND EXISTS(SELECT 1 FROM po_req_distributions prd

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
1422: WHERE prl.requisition_line_id = prd.requisition_line_id
1423: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

Line 1433: AND EXISTS(SELECT 1 FROM po_req_distributions prd

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
1436: WHERE prl.requisition_line_id = prd.requisition_line_id
1437: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

Line 1455: AND EXISTS(SELECT 1 FROM po_req_distributions prd

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
1458: WHERE prl.requisition_line_id = prd.requisition_line_id
1459: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

Line 1469: AND EXISTS(SELECT 1 FROM po_req_distributions prd

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
1472: WHERE prl.requisition_line_id = prd.requisition_line_id
1473: AND EXISTS (SELECT 1 FROM po_requisition_headers prh