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 180: FROM mtl_serial_numbers

176: CURSOR serial_validation_cursor IS
177: SELECT 'Validate-Serial'
178: FROM DUAL
179: WHERE EXISTS( SELECT 'Subinventory-not-given'
180: FROM mtl_serial_numbers
181: WHERE inventory_item_id = p_container_item_id
182: AND current_organization_id = p_organization_id
183: AND serial_number = l_current_serial
184: AND current_status IN (1, 5, 6, 7));

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

399: FETCH serial_validation_cursor INTO l_serial_validate;
400:
401: IF serial_validation_cursor%NOTFOUND THEN
402: IF (l_debug = 1) THEN
403: mdebug(l_current_serial || ' could not be found in MTL_SERIAL_NUMBERS', 1);
404: END IF;
405: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SER');
406: fnd_msg_pub.ADD;
407: RAISE fnd_api.g_exc_error;

Line 1498: FROM mtl_serial_numbers

1494: CURSOR lpn_serial_contents_cursor IS
1495: -- Bug# 1546081
1496: -- SELECT *
1497: SELECT 1
1498: FROM mtl_serial_numbers
1499: WHERE lpn_id = l_current_lpn;
1500:
1501: CURSOR lpn_cursor IS
1502: -- Bug# 1546081

Line 1511: l_lpn_serial_rec mtl_serial_numbers%ROWTYPE;

1507:
1508: l_lpn_rec wms_license_plate_numbers%ROWTYPE;
1509: --l_lpn_contents_rec WMS_LPN_CONTENTS%ROWTYPE;
1510: l_lpn_contents_rec lpn_contents_cursor%ROWTYPE;
1511: l_lpn_serial_rec mtl_serial_numbers%ROWTYPE;
1512: l_net_weight NUMBER;
1513: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1514: BEGIN
1515: -- Standard Start of API savepoint

Line 1955: FROM mtl_serial_numbers

1951: current_subinventory_code,
1952: current_locator_id,
1953: inventory_item_id,
1954: serial_number
1955: FROM mtl_serial_numbers
1956: WHERE lpn_id = l_current_lpn;
1957:
1958: -- Bug# 1546081
1959: -- l_child_lpn nested_children_cursor%ROWTYPE;

Line 2025: FROM mtl_serial_numbers

2021: CURSOR serial_validation_cursor IS
2022: SELECT 'Validate Serial'
2023: FROM DUAL
2024: WHERE EXISTS( SELECT 'X'
2025: FROM mtl_serial_numbers
2026: WHERE inventory_item_id = p_content_item_id
2027: AND current_organization_id = p_organization_id
2028: AND serial_number = l_current_serial
2029: AND current_status IN (1, 4, 5, 6, 7));

Line 2459: FROM mtl_serial_numbers

2455: -- Get the serial number current status for the current
2456: -- serial number to check if it was dynamically generated
2457: SELECT COUNT(*)
2458: INTO l_dynamic_status
2459: FROM mtl_serial_numbers
2460: WHERE inventory_item_id = p_content_item_id
2461: AND serial_number = l_current_serial
2462: AND current_organization_id = p_organization_id
2463: AND current_status = 6;

Line 2700: FROM mtl_serial_numbers

2696: CURSOR serial_validation_cursor IS
2697: SELECT 'Validate Serial'
2698: FROM DUAL
2699: WHERE EXISTS( SELECT 'X'
2700: FROM mtl_serial_numbers
2701: WHERE inventory_item_id = p_content_item_id
2702: AND current_organization_id = p_organization_id
2703: AND serial_number = l_current_serial
2704: AND current_status IN (1, 5, 6, 7));

Line 2892: FROM mtl_serial_numbers

2888: -- Get the serial number current status for the current
2889: -- serial number to check if it was dynamically generated
2890: SELECT COUNT(*)
2891: INTO l_dynamic_status
2892: FROM mtl_serial_numbers
2893: WHERE inventory_item_id = p_content_item_id
2894: AND serial_number = l_current_serial
2895: AND current_organization_id = p_organization_id
2896: AND current_status = 6;

Line 3782: FROM mtl_serial_numbers

3778: END IF;
3779:
3780: SELECT COUNT(1)
3781: INTO l_valid
3782: FROM mtl_serial_numbers
3783: WHERE lpn_id = p_lpn_id
3784: AND current_organization_id = l_organization_id
3785: AND current_status <> 4;
3786:

Line 3791: l_table_name := 'MTL_SERIAL_NUMBERS';

3787: IF l_valid > 0 THEN
3788: IF l_debug = 1 THEN
3789: mdebug('LPN : '||p_lpn_id||' has serials which are not shipped out, cannot reuse');
3790: END IF;
3791: l_table_name := 'MTL_SERIAL_NUMBERS';
3792: RAISE l_transactions_pending;
3793: END IF;
3794:
3795: SELECT COUNT(1)

Line 4131: , mtl_serial_numbers msn

4127: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4128: FROM wms_license_plate_numbers wlpn1
4129: , wms_license_plate_numbers wlpn2
4130: , wms_lpn_contents wlc
4131: , mtl_serial_numbers msn
4132: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4133: AND wlpn1.lpn_id = msn.lpn_id(+)
4134: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)
4135: AND wlpn1.lpn_id = p_lpn_id;

Line 4221: UPDATE mtl_serial_numbers

4217: , outermost_lpn_id = p_lpn_id
4218: WHERE ROWID = l_wlpn_row_id;
4219: END IF;
4220:
4221: UPDATE mtl_serial_numbers
4222: SET lpn_id = NULL
4223: WHERE lpn_id = p_lpn_id
4224: AND current_organization_id = l_organization_id;
4225:

Line 4400: , mtl_serial_numbers msn

4396: , wlpn1.homogeneous_container -- HOMOGENEOUS_CONTAINER
4397: FROM wms_license_plate_numbers wlpn1
4398: , wms_license_plate_numbers wlpn2
4399: , wms_lpn_contents wlc
4400: , mtl_serial_numbers msn
4401: WHERE wlpn1.lpn_id = wlc.parent_lpn_id(+)
4402: AND wlpn1.lpn_id = msn.lpn_id(+)
4403: AND wlpn1.lpn_id = wlpn2.parent_lpn_id(+)
4404: AND wlpn1.lpn_id = all_child_wlpn_rec.lpn_id;

Line 4450: UPDATE mtl_serial_numbers

4446: , outermost_lpn_id = all_child_wlpn_rec.lpn_id
4447: WHERE lpn_id = all_child_wlpn_rec.lpn_id;
4448: END IF;
4449:
4450: UPDATE mtl_serial_numbers
4451: SET lpn_id = NULL
4452: WHERE lpn_id = all_child_wlpn_rec.lpn_id
4453: AND current_organization_id = l_organization_id;
4454: