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_SHIPMENT_HEADERS

Line 12: vp_shipment_header_id rcv_shipment_headers.shipment_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;
16: vp_invoice_date ap_invoices.invoice_date%TYPE;

Line 13: vp_rec_date rcv_shipment_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;
16: vp_invoice_date ap_invoices.invoice_date%TYPE;
17: vp_invoice_amount ap_invoices.invoice_amount%TYPE;

Line 49: p_shipment_header_id IN rcv_shipment_headers.shipment_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,
53: p_invoice_date IN ap_invoices.invoice_date%TYPE ,

Line 50: p_receipt_date IN rcv_shipment_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,
53: p_invoice_date IN ap_invoices.invoice_date%TYPE ,
54: p_invoice_amount IN ap_invoices.invoice_amount%TYPE ,

Line 194: AND EXISTS (SELECT 1 from rcv_shipment_headers rsh

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
195: WHERE rsh.shipment_header_id = rt.shipment_header_id
196: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id)
197: AND TRUNC(rsh.creation_date) = NVL(vp_rec_date,TRUNC(rsh.creation_date))))
198: UNION

Line 213: AND EXISTS (SELECT 1 from rcv_shipment_headers rsh

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
214: WHERE rsh.shipment_header_id = rt.shipment_header_id
215: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id)
216: AND TRUNC(rsh.creation_date) = NVL(vp_rec_date,TRUNC(rsh.creation_date))));
217:

Line 539: AND EXISTS (SELECT 1 FROM rcv_shipment_headers rsh

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

Line 550: AND EXISTS (SELECT 1 FROM rcv_shipment_headers rsh

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
551: WHERE rsh.vendor_id = vp_vendor_id
552: AND rsh.shipment_header_id = rt.shipment_header_id
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))))))

Line 568: AND EXISTS (SELECT 1 FROM rcv_shipment_headers rsh

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

Line 579: AND EXISTS (SELECT 1 FROM rcv_shipment_headers rsh

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
580: WHERE rsh.vendor_id = vp_vendor_id
581: AND rsh.shipment_header_id = rt.shipment_header_id
582: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id)
583: AND TRUNC(rsh.creation_date) = NVL(vp_rec_date,TRUNC(rsh.creation_date))))));

Line 847: SELECT rsh.shipment_header_id FROM rcv_shipment_headers rsh

843: AND vendor_site_id = vp_vendor_site_id;
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

Line 859: SELECT shipment_header_id FROM rcv_shipment_headers rsh

855: AND TRUNC(ph.creation_date) = nvl(vp_po_date,TRUNC(ph.creation_date))
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

Line 874: SELECT rsh.shipment_header_id FROM rcv_shipment_headers rsh

870: WHERE shipment_header_id = rsh.shipment_header_id
871: AND session_id = vp_session_id);
872: po_rec rec_cur%ROWTYPE;
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

Line 895: SELECT shipment_header_id FROM rcv_shipment_headers rsh

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)))))
893:
894: UNION
895: SELECT shipment_header_id FROM rcv_shipment_headers rsh
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)

Line 922: SELECT shipment_header_id FROM rcv_shipment_headers rsh

918: req_rec req_cur%ROWTYPE;
919:
920:
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

Line 939: SELECT shipment_header_id FROM rcv_shipment_headers rsh

935: AND TRUNC(ap.invoice_date) = nvl(vp_invoice_date,TRUNC(ap.invoice_date))
936: AND invoice_type_lookup_code = nvl(vp_invoice_type,invoice_type_lookup_code)
937: AND invoice_amount = nvl(vp_invoice_amount,invoice_amount)))))
938: UNION
939: SELECT shipment_header_id FROM rcv_shipment_headers rsh
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)

Line 960: SELECT shipment_header_id FROM rcv_shipment_headers rsh

956: AND invoice_amount = nvl(vp_invoice_amount,invoice_amount)))));
957:
958: inv_rec inv_cur%ROWTYPE;
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

Line 980: SELECT shipment_header_id FROM rcv_shipment_headers rsh

976: AND ac.amount = nvl(vp_amount,ac.amount)
977: AND NVL(ac.treasury_pay_number,-1) = nvl(vp_treasury_pay_number,NVL(ac.treasury_pay_number,-1))
978: AND (TRUNC(ac.treasury_pay_date) = TRUNC(vp_treasury_pay_date) OR vp_treasury_pay_date IS NULL))))))
979: UNION
980: SELECT shipment_header_id FROM rcv_shipment_headers rsh
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)

Line 1227: AND EXISTS(SELECT 1 FROM rcv_shipment_headers rsh

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 )
1230: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))
1231: OR EXISTS (SELECT 1 FROM po_distributions pd

Line 1233: AND EXISTS(SELECT 1 FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh

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
1236: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )
1237: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))))

Line 1249: AND EXISTS(SELECT 1 FROM rcv_shipment_headers rsh

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 )
1252: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))
1253: OR EXISTS (SELECT 1 FROM po_distributions pd

Line 1255: AND EXISTS(SELECT 1 FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh

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
1258: AND rsh.shipment_header_id = NVL(vp_shipment_header_id,rsh.shipment_header_id )
1259: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date))))));

Line 1539: AND EXISTS(SELECT 1 FROM rcv_shipment_headers rsh

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 )
1542: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date)))))))
1543: UNION

Line 1557: AND EXISTS(SELECT 1 FROM rcv_shipment_headers rsh

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 )
1560: AND TRUNC(rsh.creation_date) = NVL( vp_rec_date,TRUNC(rsh.creation_date)))))));
1561: