APPS.CSI_WIP_TRXS_PKG dependencies on MTL_SERIAL_NUMBERS

Line 778: l_parent_serial_number mtl_serial_numbers.serial_number%type;

774:
775: l_genealogy_traced boolean := FALSE;
776:
777: l_parent_object_id number;
778: l_parent_serial_number mtl_serial_numbers.serial_number%type;
779: l_parent_item_id number;
780: l_c_ind binary_integer;
781:
782: CURSOR mog_cur(p_parent_object_id IN number) IS

Line 785: mtl_serial_numbers msn

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
789: AND msn.gen_object_id = mog.object_id

Line 866: FROM mtl_serial_numbers

862: l_gen_child_qty := 0; --fix for bug4941800
863:
864: SELECT gen_object_id
865: INTO l_parent_object_id
866: FROM mtl_serial_numbers
867: WHERE inventory_item_id = l_assy_tbl(l_a_ind).inventory_item_id
868: AND serial_number = l_assy_tbl(l_a_ind).serial_number;
869:
870: FOR mog_rec in mog_cur (l_parent_object_id)

Line 2132: mtl_serial_numbers msn

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
2136: AND msn.gen_object_id = mog.object_id

Line 2163: FROM mtl_serial_numbers

2159: debug('Parent Serial :'||l_assy_tbl(l_ind).serial_number);
2160:
2161: SELECT gen_object_id
2162: INTO l_parent_object_id
2163: FROM mtl_serial_numbers
2164: WHERE inventory_item_id = l_assy_tbl(l_ind).inventory_item_id
2165: AND serial_number = l_assy_tbl(l_ind).serial_number;
2166:
2167: l_children_count := 0;

Line 2232: FROM mtl_serial_numbers

2228: SELECT gen_object_id,
2229: parent_serial_number
2230: INTO l_child_object_id,
2231: l_parent_serial_number
2232: FROM mtl_serial_numbers
2233: WHERE inventory_item_id = p_child_item_id
2234: and serial_number = p_child_serial_number;
2235:
2236: IF l_parent_serial_number is not null THEN

Line 2243: mtl_serial_numbers msn

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
2247: AND msn.gen_object_id = mog.parent_object_id