eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_SERIAL_NUMBERS

Line 3101: l_serial_number mtl_serial_numbers.serial_number%TYPE;

3097: l_source_line_id NUMBER;
3098: l_prev_src_line_id NUMBER;
3099: l_min_del_detail_id NUMBER := 0;
3100: l_sum_req_qty NUMBER := 0;
3101: l_serial_number mtl_serial_numbers.serial_number%TYPE;
3102: l_outermost_dd_id NUMBER;
3103: l_req_qty NUMBER;
3104: l_transaction_temp_id NUMBER;
3105:

Line 3315: UPDATE mtl_serial_numbers

3311: END IF;
3312:
3313: IF l_serial_ctrl_code IN(2, 5) THEN
3314: BEGIN
3315: UPDATE mtl_serial_numbers
3316: SET current_status = 3
3317: , group_mark_id = NULL -- -1
3318: WHERE inventory_item_id = l_item_id
3319: AND current_organization_id = p_org_id

Line 3333: UPDATE mtl_serial_numbers

3329: NULL;
3330: END;
3331: ELSIF l_serial_ctrl_code = 6 THEN
3332: BEGIN
3333: UPDATE mtl_serial_numbers
3334: SET current_status = 1
3335: , group_mark_id = NULL -- -1
3336: WHERE inventory_item_id = l_item_id
3337: AND current_organization_id = p_org_id

Line 3585: DELETE FROM mtl_serial_numbers_temp

3581: DELETE FROM wms_freight_cost_temp
3582: WHERE organization_id = p_org_id
3583: AND lpn_id = l_outermost_lpn_id;
3584:
3585: DELETE FROM mtl_serial_numbers_temp
3586: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3587: FROM wms_direct_ship_temp
3588: WHERE lpn_id = p_outermost_lpn_id);
3589:

Line 3632: DELETE FROM mtl_serial_numbers_temp

3628: WHERE lpn_id = p_outermost_lpn_id;
3629:
3630: --Delete records from Mtl_Seral_Numbers_Temp if any
3631: BEGIN
3632: DELETE FROM mtl_serial_numbers_temp
3633: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3634: FROM wms_direct_ship_temp
3635: WHERE lpn_id = p_outermost_lpn_id);
3636: EXCEPTION

Line 3720: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_serial_numbers msn

3716: , wlpn.locator_id
3717: , wlc.lot_number
3718: , wlc.inventory_item_id
3719: , msn.serial_number
3720: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_serial_numbers msn
3721: WHERE wlpn.lpn_id = wlc.parent_lpn_id
3722: AND msn.lpn_id(+) = wlc.parent_lpn_id
3723: AND msn.inventory_item_id(+) = wlc.inventory_item_id
3724: AND msn.current_organization_id(+) = wlc.organization_id

Line 4045: , mtl_serial_numbers_temp msnt

4041: , msnt.time_since_mark
4042: , msnt.cycles_since_mark
4043: , msnt.number_of_repairs
4044: FROM wsh_delivery_details_ob_grp_v dd
4045: , mtl_serial_numbers_temp msnt
4046: WHERE delivery_detail_id = p_delivery_detail_id
4047: AND msnt.transaction_temp_id = p_transaction_temp_id;
4048:
4049: l_explode_detail c_explode_detail%ROWTYPE;

Line 4060: FROM mtl_serial_numbers

4056: , p_to_serial_number VARCHAR2
4057: , p_serial_length NUMBER
4058: ) IS
4059: SELECT serial_number
4060: FROM mtl_serial_numbers
4061: WHERE current_organization_id = p_organization_id
4062: AND inventory_item_id = p_inventory_item_id
4063: AND serial_number BETWEEN p_fm_serial_number AND p_to_serial_number
4064: AND current_status IN(1, 6)

Line 4073: FROM mtl_serial_numbers a

4069: , p_lpn_id NUMBER) IS
4070: SELECT serial_number,
4071: group_mark_id,
4072: reservation_id
4073: FROM mtl_serial_numbers a
4074: WHERE current_organization_id = p_organization_id
4075: AND inventory_item_id = p_inventory_item_id
4076: AND lpn_id = p_lpn_id
4077: AND current_status = 3

Line 4099: FROM mtl_serial_numbers a

4095: , p_eiun VARCHAR2) IS
4096: SELECT serial_number,
4097: group_mark_id,
4098: reservation_id
4099: FROM mtl_serial_numbers a
4100: WHERE current_organization_id = p_organization_id
4101: AND inventory_item_id = p_inventory_item_id
4102: AND lpn_id = p_lpn_id
4103: AND current_status = 3

Line 4196: -- Serial Number is lying in MTL_SERIAL_NUMBERS_TEMP

4192: IF (l_debug = 1) THEN
4193: DEBUG('P_SERIAL_CONTROL_CODE=6', 'EXPLODE_DELIVERY_DETAILS');
4194: END IF;
4195:
4196: -- Serial Number is lying in MTL_SERIAL_NUMBERS_TEMP
4197: IF (l_debug = 1) THEN
4198: DEBUG('EXPLODE delviery detail id ' || TO_CHAR(p_delivery_detail_id), 'EXPLODE_DELIVERY_DETAILS');
4199: END IF;
4200:

Line 4233: UPDATE mtl_serial_numbers

4229: IF (l_explode_detail.fm_serial_number = l_explode_detail.to_serial_number) THEN
4230: IF (l_debug = 1) THEN
4231: DEBUG('From and To Serial Numbers are Same','EXPLODE_DELIVEY_DETAILS');
4232: END IF;
4233: UPDATE mtl_serial_numbers
4234: SET serial_attribute_category = l_explode_detail.serial_attribute_category
4235: , origination_date = l_explode_detail.origination_date
4236: , c_attribute1 = l_explode_detail.c_attribute1
4237: , c_attribute2 = l_explode_detail.c_attribute2

Line 4300: 'After update mtl_serial_numbers with the attributes: c_attribute1 ' || l_explode_detail.c_attribute1

4296: l_serial_numbers_table(m) := l_explode_detail.fm_serial_number;
4297:
4298: IF (l_debug = 1) THEN
4299: DEBUG(
4300: 'After update mtl_serial_numbers with the attributes: c_attribute1 ' || l_explode_detail.c_attribute1
4301: , 'EXPLODE_DELIVERY_DETAILS'
4302: );
4303: END IF;
4304:

Line 4327: UPDATE mtl_serial_numbers_temp

4323: l_new_fm_serial := l_real_serial_prefix ||(l_serial_numeric + l_serial_quantity);
4324: l_current_to_serial := l_real_serial_prefix ||(l_serial_numeric + l_serial_quantity - 1);
4325: l_rowid := l_explode_detail.ROWID;
4326:
4327: UPDATE mtl_serial_numbers_temp
4328: SET fm_serial_number = l_new_fm_serial
4329: WHERE ROWID = l_rowid;
4330:
4331:

Line 4410: -- update the serial attributes in mtl_serial_numbers

4406: -- Determine length of numeric portion
4407: l_serial_numeric_len := LENGTH(SUBSTR(l_explode_detail.fm_serial_number,
4408: NVL(LENGTH(l_real_serial_prefix), 0) + 1));
4409:
4410: -- update the serial attributes in mtl_serial_numbers
4411: IF (l_debug = 1) THEN
4412: DEBUG(
4413: 'Before update the mtl_serial_numbers with org '
4414: || TO_CHAR(l_explode_detail.organization_id)

Line 4413: 'Before update the mtl_serial_numbers with org '

4409:
4410: -- update the serial attributes in mtl_serial_numbers
4411: IF (l_debug = 1) THEN
4412: DEBUG(
4413: 'Before update the mtl_serial_numbers with org '
4414: || TO_CHAR(l_explode_detail.organization_id)
4415: || ' item '
4416: || TO_CHAR(l_explode_detail.inventory_item_id)
4417: || ' serial '

Line 4440: -- update the serial attributes in mtl_serial_numbers

4436: INTO l_serial_number;
4437:
4438: EXIT WHEN c_serials%NOTFOUND;
4439:
4440: -- update the serial attributes in mtl_serial_numbers
4441: UPDATE mtl_serial_numbers
4442: SET serial_attribute_category = l_explode_detail.serial_attribute_category
4443: , origination_date = l_explode_detail.origination_date
4444: , c_attribute1 = l_explode_detail.c_attribute1

Line 4441: UPDATE mtl_serial_numbers

4437:
4438: EXIT WHEN c_serials%NOTFOUND;
4439:
4440: -- update the serial attributes in mtl_serial_numbers
4441: UPDATE mtl_serial_numbers
4442: SET serial_attribute_category = l_explode_detail.serial_attribute_category
4443: , origination_date = l_explode_detail.origination_date
4444: , c_attribute1 = l_explode_detail.c_attribute1
4445: , c_attribute2 = l_explode_detail.c_attribute2

Line 4551: UPDATE mtl_serial_numbers_temp

4547: ****************************/
4548: l_running_quantity := l_serial_numbers_table.COUNT;
4549:
4550: FOR j IN 1 .. l_running_quantity LOOP
4551: UPDATE mtl_serial_numbers_temp
4552: SET transaction_temp_id = x_transaction_temp_id
4553: WHERE transaction_temp_id = p_transaction_temp_id
4554: AND fm_serial_number = l_serial_numbers_table(j);
4555: END LOOP;

Line 4712: UPDATE mtl_serial_numbers

4708: /* 5506223: Because of the above, using direct update to MSN to set the
4709: * group_mark_id */
4710:
4711: BEGIN
4712: UPDATE mtl_serial_numbers
4713: SET group_mark_id = l_group_mark_id
4714: WHERE inventory_item_id = l_inventory_item_id
4715: AND serial_number = l_serial_numbers_table(n)
4716: AND current_organization_id = p_organization_id;

Line 6126: FROM mtl_serial_numbers_temp

6122: ELSE
6123: BEGIN
6124: SELECT fm_serial_number
6125: INTO l_shipping_attr(1).serial_number
6126: FROM mtl_serial_numbers_temp
6127: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6128: AND ROWNUM < 2;
6129:
6130: IF (l_debug = 1) THEN

Line 6139: DELETE FROM mtl_serial_numbers_temp

6135: , 'STAGE_LPN'
6136: );
6137: END IF;
6138:
6139: DELETE FROM mtl_serial_numbers_temp
6140: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6141: EXCEPTION
6142: WHEN NO_DATA_FOUND THEN
6143: IF (l_debug = 1) THEN

Line 6468: FROM mtl_serial_numbers_temp

6464: ELSE
6465: BEGIN
6466: SELECT fm_serial_number
6467: INTO l_shipping_attr(1).serial_number
6468: FROM mtl_serial_numbers_temp
6469: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6470: AND ROWNUM < 2;
6471:
6472: IF ( l_debug = 1 ) THEN

Line 6477: DELETE FROM mtl_serial_numbers_temp

6473: DEBUG('found fm_serial='|| l_shipping_attr(1).serial_number||
6474: ' for transaction_temp_id='||l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
6475: END IF;
6476:
6477: DELETE FROM mtl_serial_numbers_temp
6478: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6479: EXCEPTION
6480: WHEN NO_DATA_FOUND THEN
6481: IF (l_debug = 1) THEN

Line 6530: FROM mtl_serial_numbers_temp

6526: ELSE
6527: BEGIN
6528: SELECT fm_serial_number
6529: INTO l_shipping_attr(1).serial_number
6530: FROM mtl_serial_numbers_temp
6531: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6532: AND ROWNUM < 2;
6533:
6534: IF (l_debug = 1) THEN

Line 6543: DELETE FROM mtl_serial_numbers_temp

6539: , 'STAGE_LPN'
6540: );
6541: END IF;
6542:
6543: DELETE FROM mtl_serial_numbers_temp
6544: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6545: EXCEPTION
6546: WHEN NO_DATA_FOUND THEN
6547: IF (l_debug = 1) THEN

Line 6926: FROM mtl_serial_numbers_temp

6922: ELSE
6923: BEGIN
6924: SELECT fm_serial_number
6925: INTO l_shipping_attr(1).serial_number
6926: FROM mtl_serial_numbers_temp
6927: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6928: AND ROWNUM < 2;
6929:
6930: IF (l_debug = 1) THEN

Line 6939: DELETE FROM mtl_serial_numbers_temp

6935: , 'STAGE_LPN'
6936: );
6937: END IF;
6938:
6939: DELETE FROM mtl_serial_numbers_temp
6940: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6941: EXCEPTION
6942: WHEN NO_DATA_FOUND THEN
6943: IF (l_debug = 1) THEN

Line 7193: FROM mtl_serial_numbers_temp

7189: ELSE
7190: BEGIN
7191: SELECT fm_serial_number
7192: INTO l_shipping_attr(1).serial_number
7193: FROM mtl_serial_numbers_temp
7194: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
7195: AND ROWNUM < 2;
7196:
7197: IF ( l_debug = 1 ) THEN

Line 7202: DELETE FROM mtl_serial_numbers_temp

7198: DEBUG('found fm_serial='|| l_shipping_attr(1).serial_number||
7199: ' for transaction_temp_id='||l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
7200: END IF;
7201:
7202: DELETE FROM mtl_serial_numbers_temp
7203: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
7204: EXCEPTION
7205: WHEN NO_DATA_FOUND THEN
7206: IF (l_debug = 1) THEN

Line 7252: FROM mtl_serial_numbers_temp

7248: ELSE
7249: BEGIN
7250: SELECT fm_serial_number
7251: INTO l_shipping_attr(1).serial_number
7252: FROM mtl_serial_numbers_temp
7253: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
7254: AND ROWNUM < 2;
7255:
7256: IF (l_debug = 1) THEN

Line 7265: DELETE FROM mtl_serial_numbers_temp

7261: , 'STAGE_LPN'
7262: );
7263: END IF;
7264:
7265: DELETE FROM mtl_serial_numbers_temp
7266: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
7267: EXCEPTION
7268: WHEN NO_DATA_FOUND THEN
7269: IF (l_debug = 1) THEN

Line 9371: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE

9367: , lot_control VARCHAR2(5)
9368: , serial_control VARCHAR2(5)
9369: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE
9370: , reservable_type mtl_system_items_b.reservable_type%TYPE
9371: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
9372: , ont_pricing_qty_source VARCHAR2(30)
9373: );
9374: l_lpn_content_cur_rec l_lpn_content_cur_rec_typ;
9375:

Line 9554: ' FROM mtl_serial_numbers ' ||

9550: ' , lot_number ' ||
9551: ' , inventory_item_id ' ||
9552: ' , end_item_unit_number ' ||
9553: ' , COUNT(1) quantity ' ||
9554: ' FROM mtl_serial_numbers ' ||
9555: ' WHERE lpn_id IN(SELECT lpn_id ' ||
9556: ' FROM wms_license_plate_numbers ' ||
9557: ' WHERE organization_id = :p_org_id ' ||
9558: ' AND outermost_lpn_id = :p_lpn_id) ' ||