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 612: -- PO_LINES_ALL

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