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_REQUISITION_LINES

Line 10: vp_requisition_line_id po_requisition_lines.requisition_line_id%TYPE;

6: vp_vendor_site_id po_vendor_sites.vendor_site_id%TYPE;
7: vp_po_header_id po_headers.po_header_id%TYPE;
8: vp_po_date po_headers.creation_date%TYPE;
9: vp_requisition_header_id po_requisition_headers.requisition_header_id%TYPE;
10: vp_requisition_line_id po_requisition_lines.requisition_line_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;

Line 47: p_requisition_line_id IN po_requisition_lines.requisition_line_id%TYPE,

43: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE ,
44: p_po_header_id IN po_headers.po_header_id%TYPE,
45: p_po_date IN po_headers.creation_date%TYPE,
46: p_requisition_header_id IN po_requisition_headers.requisition_header_id%TYPE,
47: p_requisition_line_id IN po_requisition_lines.requisition_line_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,

Line 152: FROM po_requisition_headers prh,po_requisition_lines prl

148: FROM po_headers ph,po_lines pl,po_line_locations pll
149: WHERE ph.po_header_id = pl.po_header_id
150: AND pl.po_line_id = pll.po_line_id
151: AND EXISTS(SELECT prh.requisition_header_id,prl.requisition_line_id
152: FROM po_requisition_headers prh,po_requisition_lines prl
153: WHERE prh.requisition_header_id = prl.requisition_header_id
154: AND authorization_status = 'APPROVED'
155: AND prl.line_location_id = pll.line_location_id
156: AND prl.suggested_vendor_location = vp_supplier_site

Line 164: FROM po_requisition_headers prh,po_requisition_lines prl

160: UNION
161: SELECT rh.requisition_header_id,rh.requisition_line_id
162: FROM (SELECT DISTINCT prh.requisition_header_id,
163: prl.requisition_line_id,prl.line_location_id
164: FROM po_requisition_headers prh,po_requisition_lines prl
165: WHERE prl.requisition_header_id = prh.requisition_header_id
166: AND authorization_status = 'APPROVED'
167: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id)
168: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))) rh,

Line 175: AND NOT EXISTS (SELECT 1 FROM po_vendors pv,po_requisition_lines prl,po_vendor_sites pvs

171: AND plx.po_header_id = ph.po_header_id
172: AND ph.vendor_id = vp_vendor_id
173: AND rh.line_location_id = pll.line_location_id
174: AND ph.vendor_site_id = vp_vendor_site_id
175: AND NOT EXISTS (SELECT 1 FROM po_vendors pv,po_requisition_lines prl,po_vendor_sites pvs
176: WHERE prl.suggested_vendor_name = pv.vendor_name
177: AND prl.suggested_vendor_location = pvs.vendor_site_code
178: AND prl.requisition_line_id = rh.requisition_line_id ));
179:

Line 470: FROM po_requisition_headers prh,po_requisition_lines prl,po_line_locations pll,po_headers ph

466: l_errbuf VARCHAR2(1024);
467:
468: CURSOR po_cur IS
469: SELECT prh.requisition_header_id ,prl.requisition_line_id
470: FROM po_requisition_headers prh,po_requisition_lines prl,po_line_locations pll,po_headers ph
471: WHERE prh.requisition_header_id =prl.requisition_header_id
472: AND pll.line_location_id = prl.line_location_id
473: AND ph.po_header_id = pll.po_header_id
474: AND ph.vendor_id = vp_vendor_id

Line 482: FROM po_requisition_headers prh,po_requisition_lines prl,po_line_locations pll,po_headers ph

478: AND ph.agent_id = nvl(vp_buyer,ph.agent_id)
479: AND NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
480: UNION
481: SELECT prh.requisition_header_id ,prl.requisition_line_id
482: FROM po_requisition_headers prh,po_requisition_lines prl,po_line_locations pll,po_headers ph
483: WHERE prh.requisition_header_id = prl.requisition_header_id
484: AND pll.line_location_id = prl.line_location_id
485: AND ph.po_header_id = pll.po_header_id
486: AND ph.vendor_id = vp_vendor_id

Line 501: FROM po_requisition_headers prh,po_requisition_lines prl

497:
498:
499: CURSOR req_cur IS
500: SELECT prh.requisition_header_id,prl.requisition_line_id
501: FROM po_requisition_headers prh,po_requisition_lines prl
502: WHERE prh.requisition_header_id = prl.requisition_header_id
503: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id)
504: AND authorization_status = 'APPROVED'
505: AND prl.suggested_vendor_location = vp_supplier_site

Line 512: FROM po_requisition_headers prh,po_requisition_lines prl

508: UNION
509: SELECT rh.requisition_header_id,rh.requisition_line_id
510: FROM (SELECT DISTINCT prh.requisition_header_id,
511: prl.requisition_line_id,prl.line_location_id
512: FROM po_requisition_headers prh,po_requisition_lines prl
513: WHERE prl.requisition_header_id = prh.requisition_header_id
514: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id)
515: AND authorization_status = 'APPROVED'
516: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))) rh,

Line 522: AND NOT EXISTS (SELECT 1 FROM po_vendors pv,po_requisition_lines prl,po_vendor_sites pvs

518: WHERE plx.line_location_id = rh.line_location_id
519: AND plx.po_header_id = ph.po_header_id
520: AND ph.vendor_id = vp_vendor_id
521: AND ph.vendor_site_id = vp_vendor_site_id
522: AND NOT EXISTS (SELECT 1 FROM po_vendors pv,po_requisition_lines prl,po_vendor_sites pvs
523: WHERE prl.suggested_vendor_name = pv.vendor_name
524: AND prl.suggested_vendor_location = pvs.vendor_site_code
525: AND prl.requisition_line_id = rh.requisition_line_id );
526:

Line 531: SELECT requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl

527:
528: req_rec req_cur%ROWTYPE;
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

Line 557: SELECT requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl

553: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id)
554: AND TRUNC(rsh.creation_date) = NVL(vp_rec_date,TRUNC(rsh.creation_date))))))
555:
556: UNION
557: SELECT requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl
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)

Line 590: SELECT prl.requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl

586: rec_rec rec_cur%ROWTYPE;
587:
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

Line 621: SELECT prl.requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl

617: AND TRUNC(ai.invoice_date) = nvl(vp_invoice_date,TRUNC(ai.invoice_date))
618: AND ai.invoice_type_lookup_code = nvl(vp_invoice_type,invoice_type_lookup_code)
619: AND ai.invoice_amount = nvl(vp_invoice_amount,invoice_amount))))))))
620: UNION
621: SELECT prl.requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl
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)

Line 658: SELECT prl.requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl

654:
655: inv_rec inv_cur%ROWTYPE;
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

Line 696: SELECT prl.requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl

692: AND NVL(ac.treasury_pay_number,-1) = NVL(vp_treasury_pay_number,NVL(ac.treasury_pay_number,-1))
693: AND (TRUNC(ac.treasury_pay_date) = TRUNC(vp_treasury_pay_date)
694: OR vp_treasury_pay_date IS NULL)))))))))
695: UNION
696: SELECT prl.requisition_header_id,prl.requisition_line_id FROM po_requisition_lines prl
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)

Line 883: AND EXISTS (SELECT 1 FROM po_requisition_lines prl,po_requisition_headers prh

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
886: AND prh.requisition_header_id = NVL(vp_requisition_header_id ,prh.requisition_header_id)
887: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))

Line 888: OR 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
886: AND prh.requisition_header_id = NVL(vp_requisition_header_id ,prh.requisition_header_id)
887: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))
888: OR EXISTS (SELECT 1 FROM po_requisition_lines prl ,po_requisition_headers prh
889: WHERE prl.requisition_header_id = prh.requisition_header_id
890: AND prl.line_location_id = rt.po_line_location_id
891: AND prh.requisition_header_id = NVL(vp_requisition_header_id ,prh.requisition_header_id)
892: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date)))))

Line 906: AND EXISTS (SELECT 1 FROM po_requisition_lines prl ,po_requisition_headers prh

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
909: AND prh.requisition_header_id = NVL(vp_requisition_header_id ,prh.requisition_header_id)
910: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))

Line 911: OR 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
909: AND prh.requisition_header_id = NVL(vp_requisition_header_id ,prh.requisition_header_id)
910: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))
911: OR EXISTS (SELECT 1 FROM po_requisition_lines prl ,po_requisition_headers prh
912: WHERE prl.requisition_header_id = prh.requisition_header_id
913: AND prl.line_location_id = rt.po_line_location_id
914: AND prh.requisition_header_id = NVL(vp_requisition_header_id ,prh.requisition_header_id)
915: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date)))));

Line 1116: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

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

Line 1130: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

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

Line 1149: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

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

Line 1163: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

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
1166: WHERE prh.requisition_header_id = prl.requisition_header_id
1167: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id )

Line 1421: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

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

Line 1435: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

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
1438: WHERE prh.requisition_header_id = prl.requisition_header_id
1439: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id )

Line 1457: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

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

Line 1471: AND EXISTS (SELECT 1 FROM po_requisition_lines prl

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
1474: WHERE prh.requisition_header_id = prl.requisition_header_id
1475: AND prh.requisition_header_id = NVL(vp_requisition_header_id,prh.requisition_header_id )