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.INV_GENEALOGY_PUB dependencies on MTL_SERIAL_NUMBERS

Line 553: FROM mtl_serial_numbers msn

549: l_org_id := p_org_id;
550: ELSE
551: SELECT msn.current_organization_id
552: INTO l_org_id
553: FROM mtl_serial_numbers msn
554: WHERE msn.gen_object_id = l_object_id;
555: END IF;
556:
557: -- determine the parent org

Line 563: FROM mtl_serial_numbers msn

559: l_parent_org_id := p_parent_org_id;
560: ELSE
561: SELECT msn.current_organization_id
562: INTO l_parent_org_id
563: FROM mtl_serial_numbers msn
564: WHERE msn.gen_object_id = l_parent_object_id;
565: END IF;
566:
567: -- validate that the start date is not null

Line 595: FROM mtl_serial_numbers msn

591: l_parent_inventory_item_id := p_parent_inventory_item_id;
592: ELSE
593: SELECT msn.inventory_item_id
594: INTO l_parent_inventory_item_id
595: FROM mtl_serial_numbers msn
596: WHERE msn.gen_object_id = l_parent_object_id;
597: END IF;
598:
599: SELECT msi.eam_item_type

Line 616: FROM mtl_serial_numbers msn

612: l_inventory_item_id := p_inventory_item_id;
613: ELSE
614: SELECT msn.inventory_item_id
615: INTO l_inventory_item_id
616: FROM mtl_serial_numbers msn
617: WHERE msn.gen_object_id = l_object_id;
618: END IF;
619:
620: SELECT msi.eam_item_type

Line 661: FROM mtl_serial_numbers

657: END IF;
658:
659: SELECT serial_number
660: INTO l_serial_number
661: FROM mtl_serial_numbers
662: WHERE gen_object_id = l_object_id;
663:
664: DECLARE
665: CURSOR genealogy_entry_cur IS

Line 670: FROM mtl_object_genealogy mog, mtl_serial_numbers msn

666: SELECT mog.start_date_active start_date_active
667: , mog.end_date_active end_date_active
668: , msn.serial_number parent_serial_number
669: , msn.inventory_item_id parent_inventory_item_id
670: FROM mtl_object_genealogy mog, mtl_serial_numbers msn
671: WHERE mog.object_id = l_object_id
672: AND msn.gen_object_id = mog.parent_object_id
673: AND mog.genealogy_type = 5;
674: BEGIN

Line 816: FROM mtl_serial_numbers msn

812:
813: IF retval = 1 THEN
814: SELECT serial_number, inventory_item_id
815: INTO l_parent_serial_number, l_parent_inventory_item_id
816: FROM mtl_serial_numbers msn
817: WHERE gen_object_id = l_parent_object_id;
818:
819: begin
820: select instance_number into l_instance_number

Line 1176: -- Validate the existence of object number in MTL_SERIAL_NUMBERS

1172: fnd_msg_pub.ADD;
1173: RAISE lg_exc_error;
1174: END IF;
1175:
1176: -- Validate the existence of object number in MTL_SERIAL_NUMBERS
1177: -- or MTL_LOT_NUMBERS depending on the object type.
1178: -- If object number is not found return an error.
1179: IF p_object_type = 1 THEN
1180: IF p_object_id IS NOT NULL THEN

Line 1214: FROM mtl_serial_numbers

1210: ELSIF p_object_type = 2 THEN
1211: IF p_object_id IS NOT NULL THEN
1212: SELECT COUNT(*)
1213: INTO l_dummy
1214: FROM mtl_serial_numbers
1215: WHERE gen_object_id = p_object_id;
1216:
1217: IF l_dummy = 0 THEN
1218: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

Line 1229: FROM mtl_serial_numbers

1225: ELSE
1226: BEGIN
1227: SELECT gen_object_id
1228: INTO l_object_id
1229: FROM mtl_serial_numbers
1230: WHERE serial_number = p_object_number
1231: AND inventory_item_id = p_inventory_item_id
1232: AND current_organization_id = p_org_id;
1233: EXCEPTION

Line 1928: FROM mtl_serial_numbers

1924: IF l_inventory_item_id is NULL THEN
1925: BEGIN
1926: SELECT INVENTORY_ITEM_ID
1927: INTO l_inventory_item_id
1928: FROM mtl_serial_numbers
1929: WHERE gen_object_id = p_object_id
1930: AND current_Organization_id = p_org_id;
1931: EXCEPTION WHEN NO_DATA_FOUND THEN
1932:

Line 1933: IF (p_debug = 1) THEN mydebug('no data found ...child mtl_serial_numbers '); END IF;

1929: WHERE gen_object_id = p_object_id
1930: AND current_Organization_id = p_org_id;
1931: EXCEPTION WHEN NO_DATA_FOUND THEN
1932:
1933: IF (p_debug = 1) THEN mydebug('no data found ...child mtl_serial_numbers '); END IF;
1934: x_return_status := lg_ret_sts_error; -- R12
1935: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1936: fnd_message.set_token('ATTRIBUTE', 'l_inventory_item_id');
1937: fnd_msg_pub.ADD;

Line 1970: FROM mtl_serial_numbers

1966: IF l_parent_inventory_item_id is NULL OR l_parent_inventory_item_id = 0 THEN
1967: BEGIN
1968: SELECT INVENTORY_ITEM_ID
1969: INTO l_parent_inventory_item_id
1970: FROM mtl_serial_numbers
1971: WHERE gen_object_id = p_parent_object_id
1972: AND current_Organization_id = p_parent_org_id;
1973: EXCEPTION WHEN NO_DATA_FOUND THEN
1974: x_return_status := lg_ret_sts_error; -- R12

Line 1975: IF (p_debug = 1) THEN mydebug('no data found ...parent mtl_serial_numbers '); END IF;

1971: WHERE gen_object_id = p_parent_object_id
1972: AND current_Organization_id = p_parent_org_id;
1973: EXCEPTION WHEN NO_DATA_FOUND THEN
1974: x_return_status := lg_ret_sts_error; -- R12
1975: IF (p_debug = 1) THEN mydebug('no data found ...parent mtl_serial_numbers '); END IF;
1976: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1977: fnd_message.set_token('ATTRIBUTE', 'l_parent_inventory_item_id');
1978: fnd_msg_pub.ADD;
1979: END ;

Line 2133: -- Validate the existence of object number in MTL_SERIAL_NUMBERS

2129: END IF;
2130: RAISE lg_exc_unexpected_error;
2131: END IF;
2132:
2133: -- Validate the existence of object number in MTL_SERIAL_NUMBERS
2134: -- or MTL_LOT_NUMBERS depending on the object type.
2135: -- If object number is not found return an error.
2136:
2137: IF (p_debug = 1) THEN mydebug('Before deriving Object ID');

Line 2198: FROM mtl_serial_numbers

2194: IF p_object_id IS NOT NULL THEN
2195: IF p_validation_level = lg_fnd_valid_level_full THEN
2196: SELECT COUNT(*)
2197: INTO l_dummy
2198: FROM mtl_serial_numbers
2199: WHERE gen_object_id = p_object_id;
2200:
2201: IF l_dummy = 0 THEN
2202: x_return_status := lg_ret_sts_error; -- R12

Line 2219: FROM mtl_serial_numbers

2215: ELSE
2216: BEGIN
2217: SELECT gen_object_id
2218: INTO l_object_id
2219: FROM mtl_serial_numbers
2220: WHERE serial_number = LTRIM(RTRIM(p_object_number))
2221: AND inventory_item_id = p_inventory_item_id
2222: AND current_organization_id = p_org_id;
2223: IF (p_debug = 1) THEN mydebug('2: l_object_id: ' || l_object_id); END IF;

Line 2279: -- Validate the existence of parent object number in MTL_SERIAL_NUMBERS

2275:
2276: IF (p_debug = 1) THEN mydebug(' After deriving Object Id');
2277: mydebug('x_return_status: ' || x_return_status); END IF;
2278:
2279: -- Validate the existence of parent object number in MTL_SERIAL_NUMBERS
2280: -- or MTL_LOT_NUMBERS depending on the object type.
2281: -- If parent object number is not found return an error.
2282: l_invalid_field_msg := 'Parent Object ID';
2283: l_invalid_comb_msg := 'Parent Org, Item and Object Number Combination';

Line 2337: FROM mtl_serial_numbers

2333: mydebug('{{- Only if p_validation_level is FULL that parameters- parent object details will be validated }}');
2334: END IF;
2335: SELECT COUNT(*)
2336: INTO l_dummy
2337: FROM mtl_serial_numbers
2338: WHERE gen_object_id = p_parent_object_id;
2339:
2340: IF l_dummy = 0 THEN
2341: x_return_status := lg_ret_sts_error; -- R12

Line 2358: FROM mtl_serial_numbers

2354: ELSE
2355: BEGIN
2356: SELECT gen_object_id
2357: INTO l_parent_object_id
2358: FROM mtl_serial_numbers
2359: WHERE serial_number = LTRIM(RTRIM(p_parent_object_number))
2360: AND inventory_item_id = p_parent_inventory_item_id
2361: AND current_organization_id = p_parent_org_id;
2362: IF (p_debug = 1) THEN mydebug('2: l_parent_object_id: ' || l_parent_object_id); END IF;

Line 3017: UPDATE mtl_serial_numbers

3013: END IF;
3014:
3015: END ;
3016: END IF ;
3017: UPDATE mtl_serial_numbers
3018: SET parent_serial_number = NULL
3019: ,last_update_date = SYSDATE
3020: ,last_updated_by = -1
3021: ,last_update_login = -1