DBA Data[Home] [Help]

APPS.PO_DISTRIBUTIONS_SV dependencies on PO_LINE_LOCATIONS

Line 411: from po_line_locations_all

407:
408: delete po_distributions_all /*Bug6632095: using base table instead of view */
409: where line_location_id in
410: (select line_location_id
411: from po_line_locations_all
412: where po_release_id = x_delete_id);
413:
414: ELSIF (X_delete_entity = 'SHIPMENT') THEN
415:

Line 424: from po_line_locations

420:
421: delete po_distributions
422: where line_location_id in
423: (select line_location_id
424: from po_line_locations
425: where po_line_id = x_delete_id
426: and shipment_type in ('STANDARD', 'PLANNED'));
427:
428: ELSIF (X_delete_entity = 'HEADER') THEN

Line 614: -- PO_LINE_LOCATIONS_ALL

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:
618: -- Deletes the selected Line Location from the Database and