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_LINE_LOCATIONS

Line 123: FROM po_headers ph,po_lines pl,po_line_locations pll

119: l_errbuf VARCHAR2(1024);
120:
121: CURSOR po_cur IS
122: SELECT ph.po_header_id,pl.po_line_id,pll.line_location_id
123: FROM po_headers ph,po_lines pl,po_line_locations pll
124: WHERE ph.po_header_id = pl.po_header_id
125: AND pl.po_line_id = pll.po_line_id
126: AND vendor_id = vp_vendor_id
127: AND vendor_site_id = vp_vendor_site_id

Line 134: FROM po_headers ph,po_lines pl,po_line_locations pll

130: AND ph.agent_id = nvl(vp_buyer,ph.agent_id)
131: AND NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)
132: UNION
133: SELECT ph.po_header_id,pl.po_line_id,pll.line_location_id
134: FROM po_headers ph,po_lines pl,po_line_locations pll
135: WHERE ph.po_header_id = pl.po_header_id
136: AND pl.po_line_id = pll.po_line_id
137: AND vendor_id = vp_vendor_id
138: AND vendor_site_id = vp_vendor_site_id

Line 148: FROM po_headers ph,po_lines pl,po_line_locations pll

144: po_rec po_cur%ROWTYPE;
145:
146: CURSOR req_cur IS
147: SELECT ph.po_header_id,pl.po_line_id, pll.line_location_id
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

Line 169: po_line_locations plx,po_headers ph

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,
169: po_line_locations plx,po_headers ph
170: WHERE plx.line_location_id = rh.line_location_id
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

Line 185: FROM po_headers ph,po_line_locations pll

181: req_rec req_cur%ROWTYPE;
182:
183: CURSOR rec_cur IS
184: SELECT ph.po_header_id,pll.po_line_id,pll.line_location_id
185: FROM po_headers ph,po_line_locations pll
186: WHERE ph.po_header_id = pll.po_header_id
187: AND vendor_id = vp_vendor_id
188: AND vendor_site_id = vp_vendor_site_id
189: AND NOT EXISTS(SELECT 1 FROM fv_doc_cr_temp WHERE session_id = vp_session_id)

Line 200: FROM po_headers ph,po_line_locations pll

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
199: SELECT ph.po_header_id,pll.po_line_id ,pll.line_location_id
200: FROM po_headers ph,po_line_locations pll
201: WHERE ph.po_header_id = pll.po_header_id
202: AND vendor_id = vp_vendor_id
203: AND vendor_site_id = vp_vendor_site_id
204: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp fst

Line 220: SELECT ph.po_header_id,pll.po_line_id,pll.line_location_id FROM po_headers ph,po_line_locations pll

216: AND TRUNC(rsh.creation_date) = NVL(vp_rec_date,TRUNC(rsh.creation_date))));
217:
218: rec_rec rec_cur%ROWTYPE;
219: CURSOR inv_cur IS
220: SELECT ph.po_header_id,pll.po_line_id,pll.line_location_id FROM po_headers ph,po_line_locations pll
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)

Line 248: SELECT ph.po_header_id,pll.po_line_id ,pll.line_location_id FROM po_headers ph,po_line_locations pll

244: AND TRUNC(ap.invoice_date) = NVL(vp_invoice_date,TRUNC(ap.invoice_date))
245: AND invoice_type_lookup_code = nvl(vp_invoice_type,invoice_type_lookup_code)
246: AND invoice_amount = nvl(vp_invoice_amount,invoice_amount)))))
247: UNION
248: SELECT ph.po_header_id,pll.po_line_id ,pll.line_location_id FROM po_headers ph,po_line_locations pll
249: WHERE vendor_id = vp_vendor_id
250: AND ph.po_header_id = pll.po_header_id
251: AND vendor_site_id = vp_vendor_site_id
252: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp fst

Line 284: FROM po_headers ph,po_line_locations pll

280: inv_rec inv_cur%ROWTYPE;
281:
282: CURSOR pay_cur IS
283: SELECT ph.po_header_id,pll.po_line_id,pll.line_location_id
284: FROM po_headers ph,po_line_locations pll
285: WHERE ph.po_header_id = pll.po_header_id
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

Line 322: FROM po_headers ph,po_line_locations pll

318: AND (TRUNC(ac.treasury_pay_date) = TRUNC(vp_treasury_pay_date)
319: OR vp_treasury_pay_date IS NULL))))))
320: UNION
321: SELECT ph.po_header_id,pll.po_line_id,pll.line_location_id
322: FROM po_headers ph,po_line_locations pll
323: WHERE ph.po_header_id = pll.po_header_id
324: AND EXISTS (SELECT 1 FROM fv_doc_cr_temp fst
325: WHERE fst.po_header_id = ph.po_header_id
326: AND fst.po_line_id = pll.po_line_id

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 517: po_line_locations plx,po_headers ph

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,
517: po_line_locations plx,po_headers ph
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

Line 606: OR EXISTS (SELECT 1 FROM po_line_locations pll

602: AND ai.invoice_id = NVL(vp_invoice_id,invoice_id)
603: AND TRUNC(ai.invoice_date) = nvl(vp_invoice_date,TRUNC(ai.invoice_date))
604: AND ai.invoice_type_lookup_code = nvl(vp_invoice_type,invoice_type_lookup_code)
605: AND ai.invoice_amount = nvl(vp_invoice_amount,invoice_amount)))
606: OR EXISTS (SELECT 1 FROM po_line_locations pll
607: WHERE pll.line_location_id = pd.line_location_id
608: AND EXISTS ( SELECT 1 FROM rcv_transactions rt
609: WHERE rt.po_line_location_id = pll.line_location_id
610: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

Line 640: OR EXISTS (SELECT 1 FROM po_line_locations pll

636: AND ai.invoice_id = NVL(vp_invoice_id,invoice_id)
637: AND trunc(ai.invoice_date) = nvl(vp_invoice_date,trunc(ai.invoice_date))
638: AND ai.invoice_type_lookup_code = NVL(vp_invoice_type,invoice_type_lookup_code)
639: AND ai.invoice_amount = nvl(vp_invoice_amount,invoice_amount)))
640: OR EXISTS (SELECT 1 FROM po_line_locations pll
641: WHERE pll.line_location_id = pd.line_location_id
642: AND EXISTS (SELECT 1 FROM rcv_transactions rt
643: WHERE rt.po_line_location_id = pll.line_location_id
644: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

Line 677: OR EXISTS (SELECT 1 FROM po_line_locations pll

673: AND ac.amount = nvl(vp_amount,ac.amount)
674: AND NVL(ac.treasury_pay_number,-1) =NVL(vp_treasury_pay_number,NVL(ac.treasury_pay_number,-1))
675: AND (TRUNC(ac.treasury_pay_date) = TRUNC(vp_treasury_pay_date)
676: OR vp_treasury_pay_date IS NULL))))
677: OR EXISTS (SELECT 1 FROM po_line_locations pll
678: WHERE pll.line_location_id = pd.line_location_id
679: AND EXISTS (SELECT 1 FROM rcv_transactions rt
680: WHERE rt.po_line_location_id = pll.line_location_id
681: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

Line 717: OR EXISTS (SELECT 1 FROM po_line_locations pll

713: AND ac.amount = nvl(vp_amount,ac.amount)
714: AND NVL(ac.treasury_pay_number,-1) =NVL(vp_treasury_pay_number,NVL(ac.treasury_pay_number,-1))
715: AND (TRUNC(ac.treasury_pay_date) = TRUNC(vp_treasury_pay_date)
716: OR vp_treasury_pay_date IS NULL))))
717: OR EXISTS (SELECT 1 FROM po_line_locations pll
718: WHERE pll.line_location_id = pd.line_location_id
719: AND EXISTS (SELECT 1 FROM rcv_transactions rt
720: WHERE rt.po_line_location_id = pll.line_location_id
721: AND EXISTS (SELECT 1 FROM ap_invoice_distributions aid

Line 1124: AND EXISTS (SELECT 1 FROM po_line_locations pll

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

Line 1157: AND EXISTS (SELECT 1 FROM po_line_locations pll

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

Line 1429: AND EXISTS (SELECT 1 FROM po_line_locations pll

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

Line 1465: AND EXISTS (SELECT 1 FROM po_line_locations pll

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