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.CSI_WIP_TRXS_PKG dependencies on MTL_OBJECT_GENEALOGY

Line 784: FROM mtl_object_genealogy mog,

780: l_c_ind binary_integer;
781:
782: CURSOR mog_cur(p_parent_object_id IN number) IS
783: SELECT msn.serial_number child_serial_number
784: FROM mtl_object_genealogy mog,
785: mtl_serial_numbers msn
786: WHERE mog.parent_object_type = 2
787: AND mog.parent_object_id = p_parent_object_id
788: AND mog.object_type = 2

Line 2131: FROM mtl_object_genealogy mog,

2127:
2128: CURSOR mog_cur(p_parent_object_id IN number) IS
2129: SELECT msn.serial_number child_serial_number,
2130: msn.inventory_item_id child_item_id
2131: FROM mtl_object_genealogy mog,
2132: mtl_serial_numbers msn
2133: WHERE mog.parent_object_type = 2
2134: AND mog.parent_object_id = p_parent_object_id
2135: AND mog.object_type = 2

Line 2242: FROM mtl_object_genealogy mog,

2238: SELECT msn.serial_number,
2239: msn.inventory_item_id
2240: INTO l_parent_serial_number,
2241: l_parent_item_id
2242: FROM mtl_object_genealogy mog,
2243: mtl_serial_numbers msn
2244: WHERE mog.object_type = 2 -- serial genealogy
2245: AND mog.object_id = l_child_object_id
2246: AND mog.parent_object_type = 2 -- serial genealogy