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_CONTAINER_PUB dependencies on MTL_SERIAL_NUMBERS

Line 255: FROM mtl_serial_numbers

251: CURSOR serial_validation_cursor IS
252: SELECT 'Validate-Serial'
253: FROM DUAL
254: WHERE EXISTS( SELECT 'Subinventory-not-given'
255: FROM mtl_serial_numbers
256: WHERE inventory_item_id = p_container_item_id
257: AND current_organization_id = p_organization_id
258: AND serial_number = l_current_serial
259: AND current_status IN (1, 5, 6, 7));

Line 478: mdebug(l_current_serial || ' could not be found in MTL_SERIAL_NUMBERS', 1);

474: FETCH serial_validation_cursor INTO l_serial_validate;
475:
476: IF serial_validation_cursor%NOTFOUND THEN
477: IF (l_debug = 1) THEN
478: mdebug(l_current_serial || ' could not be found in MTL_SERIAL_NUMBERS', 1);
479: END IF;
480: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
481: fnd_msg_pub.ADD;
482: RAISE fnd_api.g_exc_error;

Line 1575: FROM mtl_serial_numbers

1571: CURSOR lpn_serial_contents_cursor IS
1572: -- Bug# 1546081
1573: -- SELECT *
1574: SELECT 1
1575: FROM mtl_serial_numbers
1576: WHERE lpn_id = l_current_lpn;
1577:
1578: CURSOR lpn_cursor IS
1579: -- Bug# 1546081

Line 1588: l_lpn_serial_rec mtl_serial_numbers%ROWTYPE;

1584:
1585: l_lpn_rec wms_license_plate_numbers%ROWTYPE;
1586: --l_lpn_contents_rec WMS_LPN_CONTENTS%ROWTYPE;
1587: l_lpn_contents_rec lpn_contents_cursor%ROWTYPE;
1588: l_lpn_serial_rec mtl_serial_numbers%ROWTYPE;
1589: l_net_weight NUMBER;
1590: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1591: BEGIN
1592: -- Standard Start of API savepoint

Line 2032: FROM mtl_serial_numbers

2028: current_subinventory_code,
2029: current_locator_id,
2030: inventory_item_id,
2031: serial_number
2032: FROM mtl_serial_numbers
2033: WHERE lpn_id = l_current_lpn;
2034:
2035: -- Bug# 1546081
2036: -- l_child_lpn nested_children_cursor%ROWTYPE;

Line 2102: FROM mtl_serial_numbers

2098: CURSOR serial_validation_cursor IS
2099: SELECT 'Validate Serial'
2100: FROM DUAL
2101: WHERE EXISTS( SELECT 'X'
2102: FROM mtl_serial_numbers
2103: WHERE inventory_item_id = p_content_item_id
2104: AND current_organization_id = p_organization_id
2105: AND serial_number = l_current_serial
2106: AND current_status IN (1, 4, 5, 6, 7));

Line 2536: FROM mtl_serial_numbers

2532: -- Get the serial number current status for the current
2533: -- serial number to check if it was dynamically generated
2534: SELECT COUNT(*)
2535: INTO l_dynamic_status
2536: FROM mtl_serial_numbers
2537: WHERE inventory_item_id = p_content_item_id
2538: AND serial_number = l_current_serial
2539: AND current_organization_id = p_organization_id
2540: AND current_status = 6;

Line 2778: FROM mtl_serial_numbers

2774: CURSOR serial_validation_cursor IS
2775: SELECT 'Validate Serial'
2776: FROM DUAL
2777: WHERE EXISTS( SELECT 'X'
2778: FROM mtl_serial_numbers
2779: WHERE inventory_item_id = p_content_item_id
2780: AND current_organization_id = p_organization_id
2781: AND serial_number = l_current_serial
2782: AND current_status IN (1, 5, 6, 7));

Line 2970: FROM mtl_serial_numbers

2966: -- Get the serial number current status for the current
2967: -- serial number to check if it was dynamically generated
2968: SELECT COUNT(*)
2969: INTO l_dynamic_status
2970: FROM mtl_serial_numbers
2971: WHERE inventory_item_id = p_content_item_id
2972: AND serial_number = l_current_serial
2973: AND current_organization_id = p_organization_id
2974: AND current_status = 6;

Line 3860: FROM mtl_serial_numbers

3856: END IF;
3857:
3858: SELECT COUNT(1)
3859: INTO l_valid
3860: FROM mtl_serial_numbers
3861: WHERE lpn_id = p_lpn_id
3862: AND current_organization_id = l_organization_id
3863: AND current_status <> 4;
3864:

Line 3869: l_table_name := 'MTL_SERIAL_NUMBERS';

3865: IF l_valid > 0 THEN
3866: IF l_debug = 1 THEN
3867: mdebug('LPN : '||p_lpn_id||' has serials which are not shipped out, cannot reuse');
3868: END IF;
3869: l_table_name := 'MTL_SERIAL_NUMBERS';
3870: RAISE l_transactions_pending;
3871: END IF;
3872:
3873: SELECT COUNT(1)

Line 4209: , mtl_serial_numbers msn

4205: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4206: FROM wms_license_plate_numbers wlpn1
4207: , wms_license_plate_numbers wlpn2
4208: , wms_lpn_contents wlc
4209: , mtl_serial_numbers msn
4210: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4211: AND wlpn1.lpn_id = msn.lpn_id(+)
4212: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)
4213: AND wlpn1.lpn_id = p_lpn_id;

Line 4299: UPDATE mtl_serial_numbers

4295: , outermost_lpn_id = p_lpn_id
4296: WHERE ROWID = l_wlpn_row_id;
4297: END IF;
4298:
4299: UPDATE mtl_serial_numbers
4300: SET lpn_id = NULL
4301: WHERE lpn_id = p_lpn_id
4302: AND current_organization_id = l_organization_id;
4303:

Line 4478: , mtl_serial_numbers msn

4474: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4475: FROM wms_license_plate_numbers wlpn1
4476: , wms_license_plate_numbers wlpn2
4477: , wms_lpn_contents wlc
4478: , mtl_serial_numbers msn
4479: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4480: AND wlpn1.lpn_id = msn.lpn_id(+)
4481: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)
4482: AND wlpn1.lpn_id = all_child_wlpn_rec.lpn_id;

Line 4528: UPDATE mtl_serial_numbers

4524: , outermost_lpn_id = all_child_wlpn_rec.lpn_id
4525: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4526: END IF;
4527:
4528: UPDATE mtl_serial_numbers
4529: SET lpn_id = NULL
4530: WHERE lpn_id = all_child_wlpn_rec.lpn_id
4531: AND current_organization_id = l_organization_id;
4532: