DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UTIL_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 268: from po_distributions_all

264: select SUM (( quantity_ordered - quantity_cancelled ) /
265: decode(quantity_ordered,0,1,quantity_ordered ) *
266: nonrecoverable_tax)
267: into l_prorated_tax
268: from po_distributions_all
269: where po_header_id = x_header_id;
270: END IF;
271:
272: IF(x_line_id is NOT NULL and x_line_location_id is NULL) THEN

Line 277: from po_distributions_all

273: select SUM (( quantity_ordered - quantity_cancelled ) /
274: decode(quantity_ordered,0,1,quantity_ordered ) *
275: nonrecoverable_tax)
276: into l_prorated_tax
277: from po_distributions_all
278: where po_header_id = x_header_id
279: and po_line_id = x_line_id;
280:
281: END IF;

Line 288: from po_distributions_all

284: select SUM (( quantity_ordered - quantity_cancelled ) /
285: decode(quantity_ordered,0,1,quantity_ordered ) *
286: nonrecoverable_tax)
287: into l_prorated_tax
288: from po_distributions_all
289: where po_header_id = x_header_id
290: and line_location_id = x_line_location_id;
291: END IF;
292:

Line 307: from po_distributions_all

303: IF(x_line_id is NULL) THEN
304:
305: select sum(amount_billed)
306: into l_amount_billed
307: from po_distributions_all
308: where po_header_id = x_header_id;
309:
310: END IF;
311:

Line 316: from po_distributions_all

312: IF(x_line_id is NOT NULL) THEN
313:
314: select sum(amount_billed)
315: into l_amount_billed
316: from po_distributions_all
317: where po_header_id = x_header_id
318: and po_line_id = x_line_id;
319:
320: END IF;