APPS.POA_EDW_SPEND_PKG dependencies on PO_LINES_ALL

Line 39: po_lines_all pol,

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

Line 77: po_lines_all pol

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
80: and pod.po_line_id = pol.po_line_id
81: and pod.line_location_id = pll.line_location_id

Line 116: po_lines_all plc,

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

Line 167: po_lines_all pol,

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

Line 205: po_lines_all pol

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
207: and pod.po_header_id = poh.po_header_id
208: and pod.po_line_id = pol.po_line_id
209: and pod.line_location_id = pll.line_location_id

Line 240: po_lines_all pol,

236: (nvl(pod.quantity_ordered,0) - nvl(pod.quantity_cancelled,0))
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

Line 386: po_lines_all pol,

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,
390: po_approved_supplier_list pasl

Line 404: po_lines_all pol2,

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 =
408: pasl.using_organization_id