APPS.PO_DISTRIBUTIONS_SV dependencies on PO_LINES

Line 167: po_lines pol

163: select nvl(sum(decode(pol.order_type_lookup_code,'RATE',pod.amount_ordered,
164: 'FIXED PRICE',pod.amount_ordered,pod.quantity_ordered)),0)
165: into x_total
166: from po_distributions pod,
167: po_lines pol
168: where pod.po_line_id = pol.po_line_id
169: and pod.line_location_id = x_line_location_id;
170:
171:

Line 613: -- PO_LINES_ALL

609: --Pre-reqs:
610: -- Before calling this procedure one must call validate_delete_line_loc
611: -- to ensure that deletion of the line location is a valid action
612: --Modifies:
613: -- PO_LINES_ALL
614: -- PO_LINE_LOCATIONS_ALL
615: --Locks:
616: -- None
617: --Function: