APPS.POA_EDW_SPEND_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 40: po_line_locations_all pll,

36: )
37: INTO v_stdpo_amt
38: FROM po_headers_all poh,
39: po_lines_all pol,
40: po_line_locations_all pll,
41: po_distributions_all pod
42: WHERE pod.po_header_id = poh.po_header_id
43: and pod.line_location_id = pll.line_location_id
44: and pol.po_header_id = poh.po_header_id

Line 75: po_line_locations_all pll,

71: )
72: INTO v_amt_released
73: FROM po_releases_all por,
74: po_headers_all poh,
75: po_line_locations_all pll,
76: po_distributions_all pod,
77: po_lines_all pol
78: WHERE pod.po_release_id = por.po_release_id
79: and pod.po_header_id = poh.po_header_id

Line 117: po_line_locations_all pll,

113: INTO v_amt_released
114: FROM po_headers_all poh,
115: po_headers_all poh2,
116: po_lines_all plc,
117: po_line_locations_all pll,
118: po_distributions_all pod
119: WHERE pod.po_header_id = poh.po_header_id
120: and pod.po_line_id = plc.po_line_id
121: and pod.line_location_id = pll.line_location_id

Line 168: po_line_locations_all pll,

164: )
165: INTO v_stdpo_amt
166: FROM po_headers_all poh,
167: po_lines_all pol,
168: po_line_locations_all pll,
169: po_distributions_all pod
170: WHERE pod.po_header_id = poh.po_header_id
171: and pod.line_location_id = pll.line_location_id
172: and pol.po_header_id = poh.po_header_id

Line 202: po_line_locations_all pll,

198: )
199: )
200: INTO v_amt_released
201: FROM po_distributions_all pod,
202: po_line_locations_all pll,
203: po_headers_all poh,
204: po_releases_all por,
205: po_lines_all pol
206: WHERE pod.po_release_id = por.po_release_id

Line 241: po_line_locations_all pll,

237: ))
238: INTO v_stdpo_qty
239: FROM po_headers_all poh,
240: po_lines_all pol,
241: po_line_locations_all pll,
242: po_distributions_all pod
243: WHERE pod.po_header_id = poh.po_header_id
244: and pod.line_location_id = pll.line_location_id
245: and pol.po_header_id = poh.po_header_id

Line 260: po_line_locations_all pll,

256: 1, nvl(pod.quantity_delivered,0), nvl(pod.quantity_billed,0))),
257: (nvl(pod.quantity_ordered,0) - nvl(pod.quantity_cancelled,0))))
258: INTO v_qty_released
259: FROM po_distributions_all pod,
260: po_line_locations_all pll,
261: po_headers_all poh,
262: po_releases_all por
263: WHERE pod.po_release_id = por.po_release_id
264: and pod.po_header_id = poh.po_header_id

Line 385: po_line_locations_all pll,

381:
382: SELECT decode(max('Y'), 'Y', 'Y', 'N')
383: INTO v_supp_approved
384: FROM po_distributions_all pod,
385: po_line_locations_all pll,
386: po_lines_all pol,
387: po_headers_all poh,
388: po_asl_status_rules pasr,
389: po_asl_statuses pas,

Line 403: FROM po_line_locations_all pll2,

399: OR
400: (pasl.using_organization_id = -1
401: and not exists
402: (SELECT 'local exists with global record'
403: FROM po_line_locations_all pll2,
404: po_lines_all pol2,
405: po_headers_all poh2,
406: po_approved_supplier_list pasl2
407: WHERE pll2.ship_to_organization_id =