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 551: FROM mtl_serial_numbers msn

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

Line 561: FROM mtl_serial_numbers msn

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

Line 593: FROM mtl_serial_numbers msn

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

Line 614: FROM mtl_serial_numbers msn

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

Line 659: FROM mtl_serial_numbers

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

Line 668: FROM mtl_object_genealogy mog, mtl_serial_numbers msn

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

Line 814: FROM mtl_serial_numbers msn

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

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

1152: fnd_msg_pub.ADD;
1153: RAISE lg_exc_error;
1154: END IF;
1155:
1156: -- Validate the existence of object number in MTL_SERIAL_NUMBERS
1157: -- or MTL_LOT_NUMBERS depending on the object type.
1158: -- If object number is not found return an error.
1159: IF p_object_type = 1 THEN
1160: IF p_object_id IS NOT NULL THEN

Line 1194: FROM mtl_serial_numbers

1190: ELSIF p_object_type = 2 THEN
1191: IF p_object_id IS NOT NULL THEN
1192: SELECT COUNT(*)
1193: INTO l_dummy
1194: FROM mtl_serial_numbers
1195: WHERE gen_object_id = p_object_id;
1196:
1197: IF l_dummy = 0 THEN
1198: fnd_message.set_name('INV', 'INV_FIELD_INVALID');

Line 1209: FROM mtl_serial_numbers

1205: ELSE
1206: BEGIN
1207: SELECT gen_object_id
1208: INTO l_object_id
1209: FROM mtl_serial_numbers
1210: WHERE serial_number = p_object_number
1211: AND inventory_item_id = p_inventory_item_id
1212: AND current_organization_id = p_org_id;
1213: EXCEPTION

Line 1905: FROM mtl_serial_numbers

1901: IF l_inventory_item_id is NULL THEN
1902: BEGIN
1903: SELECT INVENTORY_ITEM_ID
1904: INTO l_inventory_item_id
1905: FROM mtl_serial_numbers
1906: WHERE gen_object_id = p_object_id
1907: AND current_Organization_id = p_org_id;
1908: EXCEPTION WHEN NO_DATA_FOUND THEN
1909:

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

1906: WHERE gen_object_id = p_object_id
1907: AND current_Organization_id = p_org_id;
1908: EXCEPTION WHEN NO_DATA_FOUND THEN
1909:
1910: IF (p_debug = 1) THEN mydebug('no data found ...child mtl_serial_numbers '); END IF;
1911: x_return_status := lg_ret_sts_error; -- R12
1912: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1913: fnd_message.set_token('ATTRIBUTE', 'l_inventory_item_id');
1914: fnd_msg_pub.ADD;

Line 1947: FROM mtl_serial_numbers

1943: IF l_parent_inventory_item_id is NULL OR l_parent_inventory_item_id = 0 THEN
1944: BEGIN
1945: SELECT INVENTORY_ITEM_ID
1946: INTO l_parent_inventory_item_id
1947: FROM mtl_serial_numbers
1948: WHERE gen_object_id = p_parent_object_id
1949: AND current_Organization_id = p_parent_org_id;
1950: EXCEPTION WHEN NO_DATA_FOUND THEN
1951: x_return_status := lg_ret_sts_error; -- R12

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

1948: WHERE gen_object_id = p_parent_object_id
1949: AND current_Organization_id = p_parent_org_id;
1950: EXCEPTION WHEN NO_DATA_FOUND THEN
1951: x_return_status := lg_ret_sts_error; -- R12
1952: IF (p_debug = 1) THEN mydebug('no data found ...parent mtl_serial_numbers '); END IF;
1953: fnd_message.set_name('INV', 'INV_ATTRIBUTE_REQUIRED');
1954: fnd_message.set_token('ATTRIBUTE', 'l_parent_inventory_item_id');
1955: fnd_msg_pub.ADD;
1956: END ;

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

2106: END IF;
2107: RAISE lg_exc_unexpected_error;
2108: END IF;
2109:
2110: -- Validate the existence of object number in MTL_SERIAL_NUMBERS
2111: -- or MTL_LOT_NUMBERS depending on the object type.
2112: -- If object number is not found return an error.
2113:
2114: IF (p_debug = 1) THEN mydebug('Before deriving Object ID');

Line 2175: FROM mtl_serial_numbers

2171: IF p_object_id IS NOT NULL THEN
2172: IF p_validation_level = lg_fnd_valid_level_full THEN
2173: SELECT COUNT(*)
2174: INTO l_dummy
2175: FROM mtl_serial_numbers
2176: WHERE gen_object_id = p_object_id;
2177:
2178: IF l_dummy = 0 THEN
2179: x_return_status := lg_ret_sts_error; -- R12

Line 2196: FROM mtl_serial_numbers

2192: ELSE
2193: BEGIN
2194: SELECT gen_object_id
2195: INTO l_object_id
2196: FROM mtl_serial_numbers
2197: WHERE serial_number = LTRIM(RTRIM(p_object_number))
2198: AND inventory_item_id = p_inventory_item_id
2199: AND current_organization_id = p_org_id;
2200: IF (p_debug = 1) THEN mydebug('2: l_object_id: ' || l_object_id); END IF;

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

2252:
2253: IF (p_debug = 1) THEN mydebug(' After deriving Object Id');
2254: mydebug('x_return_status: ' || x_return_status); END IF;
2255:
2256: -- Validate the existence of parent object number in MTL_SERIAL_NUMBERS
2257: -- or MTL_LOT_NUMBERS depending on the object type.
2258: -- If parent object number is not found return an error.
2259: l_invalid_field_msg := 'Parent Object ID';
2260: l_invalid_comb_msg := 'Parent Org, Item and Object Number Combination';

Line 2314: FROM mtl_serial_numbers

2310: mydebug('{{- Only if p_validation_level is FULL that parameters- parent object details will be validated }}');
2311: END IF;
2312: SELECT COUNT(*)
2313: INTO l_dummy
2314: FROM mtl_serial_numbers
2315: WHERE gen_object_id = p_parent_object_id;
2316:
2317: IF l_dummy = 0 THEN
2318: x_return_status := lg_ret_sts_error; -- R12

Line 2335: FROM mtl_serial_numbers

2331: ELSE
2332: BEGIN
2333: SELECT gen_object_id
2334: INTO l_parent_object_id
2335: FROM mtl_serial_numbers
2336: WHERE serial_number = LTRIM(RTRIM(p_parent_object_number))
2337: AND inventory_item_id = p_parent_inventory_item_id
2338: AND current_organization_id = p_parent_org_id;
2339: IF (p_debug = 1) THEN mydebug('2: l_parent_object_id: ' || l_parent_object_id); END IF;

Line 2994: UPDATE mtl_serial_numbers

2990: END IF;
2991:
2992: END ;
2993: END IF ;
2994: UPDATE mtl_serial_numbers
2995: SET parent_serial_number = NULL
2996: ,last_update_date = SYSDATE
2997: ,last_updated_by = -1
2998: ,last_update_login = -1