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 2945: l_serial_number mtl_serial_numbers.serial_number%TYPE;

2941: l_source_line_id NUMBER;
2942: l_prev_src_line_id NUMBER;
2943: l_min_del_detail_id NUMBER := 0;
2944: l_sum_req_qty NUMBER := 0;
2945: l_serial_number mtl_serial_numbers.serial_number%TYPE;
2946: l_outermost_dd_id NUMBER;
2947: l_req_qty NUMBER;
2948: l_transaction_temp_id NUMBER;
2949:

Line 3139: UPDATE mtl_serial_numbers

3135: END IF;
3136:
3137: IF l_serial_ctrl_code IN(2, 5) THEN
3138: BEGIN
3139: UPDATE mtl_serial_numbers
3140: SET current_status = 3
3141: , group_mark_id = NULL -- -1
3142: WHERE inventory_item_id = l_item_id
3143: AND current_organization_id = p_org_id

Line 3157: UPDATE mtl_serial_numbers

3153: NULL;
3154: END;
3155: ELSIF l_serial_ctrl_code = 6 THEN
3156: BEGIN
3157: UPDATE mtl_serial_numbers
3158: SET current_status = 1
3159: , group_mark_id = NULL -- -1
3160: WHERE inventory_item_id = l_item_id
3161: AND current_organization_id = p_org_id

Line 3395: DELETE FROM mtl_serial_numbers_temp

3391: DELETE FROM wms_freight_cost_temp
3392: WHERE organization_id = p_org_id
3393: AND lpn_id = l_outermost_lpn_id;
3394:
3395: DELETE FROM mtl_serial_numbers_temp
3396: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3397: FROM wms_direct_ship_temp
3398: WHERE lpn_id = p_outermost_lpn_id);
3399:

Line 3442: DELETE FROM mtl_serial_numbers_temp

3438: WHERE lpn_id = p_outermost_lpn_id;
3439:
3440: --Delete records from Mtl_Seral_Numbers_Temp if any
3441: BEGIN
3442: DELETE FROM mtl_serial_numbers_temp
3443: WHERE transaction_temp_id IN(SELECT transaction_temp_id
3444: FROM wms_direct_ship_temp
3445: WHERE lpn_id = p_outermost_lpn_id);
3446: EXCEPTION

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

3525: , wlpn.locator_id
3526: , wlc.lot_number
3527: , wlc.inventory_item_id
3528: , msn.serial_number
3529: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_serial_numbers msn
3530: WHERE wlpn.lpn_id = wlc.parent_lpn_id
3531: AND msn.lpn_id(+) = wlc.parent_lpn_id
3532: AND msn.inventory_item_id(+) = wlc.inventory_item_id
3533: AND msn.current_organization_id(+) = wlc.organization_id

Line 3843: , mtl_serial_numbers_temp msnt

3839: , msnt.time_since_mark
3840: , msnt.cycles_since_mark
3841: , msnt.number_of_repairs
3842: FROM wsh_delivery_details_ob_grp_v dd
3843: , mtl_serial_numbers_temp msnt
3844: WHERE delivery_detail_id = p_delivery_detail_id
3845: AND msnt.transaction_temp_id = p_transaction_temp_id;
3846:
3847: l_explode_detail c_explode_detail%ROWTYPE;

Line 3858: FROM mtl_serial_numbers

3854: , p_to_serial_number VARCHAR2
3855: , p_serial_length NUMBER
3856: ) IS
3857: SELECT serial_number
3858: FROM mtl_serial_numbers
3859: WHERE current_organization_id = p_organization_id
3860: AND inventory_item_id = p_inventory_item_id
3861: AND serial_number BETWEEN p_fm_serial_number AND p_to_serial_number
3862: AND current_status IN(1, 6)

Line 3871: FROM mtl_serial_numbers a

3867: , p_lpn_id NUMBER) IS
3868: SELECT serial_number,
3869: group_mark_id,
3870: reservation_id
3871: FROM mtl_serial_numbers a
3872: WHERE current_organization_id = p_organization_id
3873: AND inventory_item_id = p_inventory_item_id
3874: AND lpn_id = p_lpn_id
3875: AND current_status = 3

Line 3897: FROM mtl_serial_numbers a

3893: , p_eiun VARCHAR2) IS
3894: SELECT serial_number,
3895: group_mark_id,
3896: reservation_id
3897: FROM mtl_serial_numbers a
3898: WHERE current_organization_id = p_organization_id
3899: AND inventory_item_id = p_inventory_item_id
3900: AND lpn_id = p_lpn_id
3901: AND current_status = 3

Line 3994: -- Serial Number is lying in MTL_SERIAL_NUMBERS_TEMP

3990: IF (l_debug = 1) THEN
3991: DEBUG('P_SERIAL_CONTROL_CODE=6', 'EXPLODE_DELIVERY_DETAILS');
3992: END IF;
3993:
3994: -- Serial Number is lying in MTL_SERIAL_NUMBERS_TEMP
3995: IF (l_debug = 1) THEN
3996: DEBUG('EXPLODE delviery detail id ' || TO_CHAR(p_delivery_detail_id), 'EXPLODE_DELIVERY_DETAILS');
3997: END IF;
3998:

Line 4031: UPDATE mtl_serial_numbers

4027: IF (l_explode_detail.fm_serial_number = l_explode_detail.to_serial_number) THEN
4028: IF (l_debug = 1) THEN
4029: DEBUG('From and To Serial Numbers are Same','EXPLODE_DELIVEY_DETAILS');
4030: END IF;
4031: UPDATE mtl_serial_numbers
4032: SET serial_attribute_category = l_explode_detail.serial_attribute_category
4033: , origination_date = l_explode_detail.origination_date
4034: , c_attribute1 = l_explode_detail.c_attribute1
4035: , c_attribute2 = l_explode_detail.c_attribute2

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

4094: l_serial_numbers_table(m) := l_explode_detail.fm_serial_number;
4095:
4096: IF (l_debug = 1) THEN
4097: DEBUG(
4098: 'After update mtl_serial_numbers with the attributes: c_attribute1 ' || l_explode_detail.c_attribute1
4099: , 'EXPLODE_DELIVERY_DETAILS'
4100: );
4101: END IF;
4102:

Line 4125: UPDATE mtl_serial_numbers_temp

4121: l_new_fm_serial := l_real_serial_prefix ||(l_serial_numeric + l_serial_quantity);
4122: l_current_to_serial := l_real_serial_prefix ||(l_serial_numeric + l_serial_quantity - 1);
4123: l_rowid := l_explode_detail.ROWID;
4124:
4125: UPDATE mtl_serial_numbers_temp
4126: SET fm_serial_number = l_new_fm_serial
4127: WHERE ROWID = l_rowid;
4128:
4129:

Line 4208: -- update the serial attributes in mtl_serial_numbers

4204: -- Determine length of numeric portion
4205: l_serial_numeric_len := LENGTH(SUBSTR(l_explode_detail.fm_serial_number,
4206: NVL(LENGTH(l_real_serial_prefix), 0) + 1));
4207:
4208: -- update the serial attributes in mtl_serial_numbers
4209: IF (l_debug = 1) THEN
4210: DEBUG(
4211: 'Before update the mtl_serial_numbers with org '
4212: || TO_CHAR(l_explode_detail.organization_id)

Line 4211: 'Before update the mtl_serial_numbers with org '

4207:
4208: -- update the serial attributes in mtl_serial_numbers
4209: IF (l_debug = 1) THEN
4210: DEBUG(
4211: 'Before update the mtl_serial_numbers with org '
4212: || TO_CHAR(l_explode_detail.organization_id)
4213: || ' item '
4214: || TO_CHAR(l_explode_detail.inventory_item_id)
4215: || ' serial '

Line 4238: -- update the serial attributes in mtl_serial_numbers

4234: INTO l_serial_number;
4235:
4236: EXIT WHEN c_serials%NOTFOUND;
4237:
4238: -- update the serial attributes in mtl_serial_numbers
4239: UPDATE mtl_serial_numbers
4240: SET serial_attribute_category = l_explode_detail.serial_attribute_category
4241: , origination_date = l_explode_detail.origination_date
4242: , c_attribute1 = l_explode_detail.c_attribute1

Line 4239: UPDATE mtl_serial_numbers

4235:
4236: EXIT WHEN c_serials%NOTFOUND;
4237:
4238: -- update the serial attributes in mtl_serial_numbers
4239: UPDATE mtl_serial_numbers
4240: SET serial_attribute_category = l_explode_detail.serial_attribute_category
4241: , origination_date = l_explode_detail.origination_date
4242: , c_attribute1 = l_explode_detail.c_attribute1
4243: , c_attribute2 = l_explode_detail.c_attribute2

Line 4349: UPDATE mtl_serial_numbers_temp

4345: ****************************/
4346: l_running_quantity := l_serial_numbers_table.COUNT;
4347:
4348: FOR j IN 1 .. l_running_quantity LOOP
4349: UPDATE mtl_serial_numbers_temp
4350: SET transaction_temp_id = x_transaction_temp_id
4351: WHERE transaction_temp_id = p_transaction_temp_id
4352: AND fm_serial_number = l_serial_numbers_table(j);
4353: END LOOP;

Line 4510: UPDATE mtl_serial_numbers

4506: /* 5506223: Because of the above, using direct update to MSN to set the
4507: * group_mark_id */
4508:
4509: BEGIN
4510: UPDATE mtl_serial_numbers
4511: SET group_mark_id = l_group_mark_id
4512: WHERE inventory_item_id = l_inventory_item_id
4513: AND serial_number = l_serial_numbers_table(n)
4514: AND current_organization_id = p_organization_id;

Line 5779: FROM mtl_serial_numbers_temp

5775: ELSE
5776: BEGIN
5777: SELECT fm_serial_number
5778: INTO l_shipping_attr(1).serial_number
5779: FROM mtl_serial_numbers_temp
5780: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
5781: AND ROWNUM < 2;
5782:
5783: IF (l_debug = 1) THEN

Line 5793: DELETE FROM mtl_serial_numbers_temp

5789: , 'STAGE_LPN'
5790: );
5791: END IF;
5792:
5793: DELETE FROM mtl_serial_numbers_temp
5794: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
5795: EXCEPTION
5796: WHEN NO_DATA_FOUND THEN
5797: IF (l_debug = 1) THEN

Line 6045: FROM mtl_serial_numbers_temp

6041: ELSE
6042: BEGIN
6043: SELECT fm_serial_number
6044: INTO l_shipping_attr(1).serial_number
6045: FROM mtl_serial_numbers_temp
6046: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6047: AND ROWNUM < 2;
6048:
6049: IF ( l_debug = 1 ) THEN

Line 6054: DELETE FROM mtl_serial_numbers_temp

6050: DEBUG('found fm_serial='|| l_shipping_attr(1).serial_number||
6051: ' for transaction_temp_id='||l_invpcinrectype.transaction_temp_id, 'STAGE_LPN');
6052: END IF;
6053:
6054: DELETE FROM mtl_serial_numbers_temp
6055: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6056: EXCEPTION
6057: WHEN NO_DATA_FOUND THEN
6058: IF (l_debug = 1) THEN

Line 6134: FROM mtl_serial_numbers_temp

6130: ELSE
6131: BEGIN
6132: SELECT fm_serial_number
6133: INTO l_shipping_attr(1).serial_number
6134: FROM mtl_serial_numbers_temp
6135: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id
6136: AND ROWNUM < 2;
6137:
6138: IF (l_debug = 1) THEN

Line 6148: DELETE FROM mtl_serial_numbers_temp

6144: , 'STAGE_LPN'
6145: );
6146: END IF;
6147:
6148: DELETE FROM mtl_serial_numbers_temp
6149: WHERE transaction_temp_id = l_invpcinrectype.transaction_temp_id;
6150: EXCEPTION
6151: WHEN NO_DATA_FOUND THEN
6152: IF (l_debug = 1) THEN

Line 8253: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE

8249: , lot_control VARCHAR2(5)
8250: , serial_control VARCHAR2(5)
8251: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE
8252: , reservable_type mtl_system_items_b.reservable_type%TYPE
8253: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
8254: , ont_pricing_qty_source VARCHAR2(30)
8255: );
8256: l_lpn_content_cur_rec l_lpn_content_cur_rec_typ;
8257:

Line 8401: ' FROM mtl_serial_numbers ' ||

8397: ' , lot_number ' ||
8398: ' , inventory_item_id ' ||
8399: ' , end_item_unit_number ' ||
8400: ' , COUNT(1) quantity ' ||
8401: ' FROM mtl_serial_numbers ' ||
8402: ' WHERE lpn_id IN(SELECT lpn_id ' ||
8403: ' FROM wms_license_plate_numbers ' ||
8404: ' WHERE organization_id = :p_org_id ' ||
8405: ' AND outermost_lpn_id = :p_lpn_id) ' ||