APPS.POA_EDW_SPEND_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 41: po_distributions_all pod

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
45: and pll.po_line_id = pol.po_line_id

Line 76: po_distributions_all pod,

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

Line 118: po_distributions_all pod

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
122: and plc.contract_id = poh2.po_header_id

Line 169: po_distributions_all pod

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
173: and pll.po_line_id = pol.po_line_id

Line 201: FROM po_distributions_all pod,

197: * nvl(pll.price_override,0) ))
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

Line 242: po_distributions_all pod

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
246: and pll.po_line_id = pol.po_line_id

Line 259: FROM po_distributions_all pod,

255: - nvl(pod.quantity_billed,0)),
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

Line 384: FROM po_distributions_all pod,

380:
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,