APPS.PO_LINES_SV4 dependencies on PO_LINE_LOCATIONS

Line 105: FROM po_line_locations_all

101: BEGIN
102:
103: SELECT count('Price Breaks with Effectivity Dates')
104: INTO l_count
105: FROM po_line_locations_all
106: WHERE po_line_id = p_po_line_id
107: AND ( ( start_date IS NOT NULL )
108: OR ( end_date IS NOT NULL ) );
109:

Line 204: from po_line_locations

200: --< NBD TZ/Timestamp FPJ End >
201: into X_line_location_id,
202: X_promised_date,
203: X_need_by
204: from po_line_locations
205: where po_line_id = X_po_line_id;
206:
207:
208: exception

Line 416: FROM po_line_locations

412: INTO X_quantity_received,
413: X_quantity_billed,
414: X_amount_received,
415: X_amount_billed
416: FROM po_line_locations
417: WHERE po_line_id = X_po_line_id
418: AND shipment_type in ('STANDARD', 'PLANNED');
419:
420: X_Progress := '030';

Line 450: FROM po_line_locations

446: )
447: )
448: INTO X_quantity_released,
449: X_amount_released
450: FROM po_line_locations
451: WHERE po_header_id = X_po_header_id and
452: shipment_type = 'BLANKET'and
453: po_line_id = X_po_line_id;
454:

Line 475: FROM po_line_locations

471: sum(price_override* (nvl(quantity,0) -
472: nvl(quantity_cancelled,0)))
473: INTO X_quantity_released,
474: X_amount_released
475: FROM po_line_locations
476: WHERE po_header_id = X_po_header_id and
477: shipment_type = 'SCHEDULED' and
478: po_line_id = X_po_line_id;
479: end if;