APPS.WSH_SC_PLD_PKG dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 475: -- Takes individual lines from MTL_SERIAL_NUMBERS_TEMP that

471: --
472: -- Name
473: -- Explode_Lines
474: -- Purpose
475: -- Takes individual lines from MTL_SERIAL_NUMBERS_TEMP that
476: -- are under serial number control and explodes them into multiple
477: -- lines based on the serial numbers entered.
478: -- Arguments
479: -- X_Picking_Line_Detail_Id for which is under Serial number

Line 485: -- for every line in MTL_SERIAL_NUMBERS_TEMP.

481: --
482: -- Notes
483: -- Assumptions: The package assumes that it will be called when
484: -- there is one line in SO_PICKING_LINE_DETAILS
485: -- for every line in MTL_SERIAL_NUMBERS_TEMP.
486: --
487:
488:
489: PROCEDURE Explode_Lines( X_Picking_Line_Detail_Id IN NUMBER)

Line 501: FROM mtl_serial_numbers_temp msnt,

497: msnt.vendor_serial_number,
498: msnt.fm_serial_number,
499: msnt.to_serial_number,
500: msnt.serial_prefix
501: FROM mtl_serial_numbers_temp msnt,
502: so_picking_line_details pld
503: WHERE pld.picking_line_detail_id = pk_line_detail_id
504: AND pld.transaction_temp_id = msnt.transaction_temp_id(+)
505: ORDER BY msnt.transaction_temp_id;

Line 652: DELETE FROM mtl_serial_numbers_temp

648: PROCEDURE Delete_From_Msnt(X_Delivery_Id NUMBER ) IS
649:
650: BEGIN
651:
652: DELETE FROM mtl_serial_numbers_temp
653: WHERE transaction_temp_id in
654: (SELECT transaction_temp_id
655: FROM so_picking_line_details
656: WHERE delivery_id = X_Delivery_Id );