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_HEADERS

Line 9: vp_requisition_header_id po_requisition_headers.requisition_header_id%TYPE;

5: vp_vendor_id po_vendors.vendor_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;

Line 11: vp_req_date po_requisition_headers.creation_date%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;
15: vp_invoice_id ap_invoices.invoice_id%TYPE;

Line 46: p_requisition_header_id IN po_requisition_headers.requisition_header_id%TYPE,

42: p_vendor_id IN po_vendors.vendor_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,

Line 48: p_req_date IN po_requisition_headers.creation_date%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,
52: p_invoice_id IN ap_invoices.invoice_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 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 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 1118: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

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 )
1121: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))
1122: OR EXISTS (SELECT 1 FROM rcv_transactions rt

Line 1132: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

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 )
1135: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))))))
1136: UNION

Line 1151: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

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 )
1154: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))
1155: OR EXISTS (SELECT 1 FROM rcv_transactions rt

Line 1165: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

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 )
1168: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))))));
1169:

Line 1423: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

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 )
1426: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))
1427: OR EXISTS (SELECT 1 FROM rcv_transactions rt

Line 1437: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

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 )
1440: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date)))))))))))
1441:

Line 1459: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

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 )
1462: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date))))))
1463: OR EXISTS (SELECT 1 FROM rcv_transactions rt

Line 1473: AND EXISTS (SELECT 1 FROM po_requisition_headers prh

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 )
1476: AND TRUNC(prh.creation_date) = NVL(vp_req_date,TRUNC(prh.creation_date)))))))))));
1477: req_rec req_cur%ROWTYPE;