APPS.CSI_WIP_TRXS_PKG dependencies on MTL_SERIAL_NUMBERS

Line 792: l_parent_serial_number mtl_serial_numbers.serial_number%type;

788:
789: l_genealogy_traced boolean := FALSE;
790:
791: l_parent_object_id number;
792: l_parent_serial_number mtl_serial_numbers.serial_number%type;
793: l_parent_item_id number;
794: l_c_ind binary_integer;
795:
796: CURSOR mog_cur(p_parent_object_id IN number) IS

Line 800: mtl_serial_numbers msn,

796: CURSOR mog_cur(p_parent_object_id IN number) IS
797: --Changed for Bug 12636010
798: SELECT msn.serial_number child_serial_number
799: FROM mtl_object_genealogy mog,
800: mtl_serial_numbers msn,
801: mtl_system_items_b msib
802: WHERE mog.parent_object_type = 2
803: AND msib.inventory_item_id = msn.inventory_item_id
804: AND msib.organization_id = msn.current_organization_id

Line 886: FROM mtl_serial_numbers

882: l_gen_child_qty := 0; --fix for bug4941800
883:
884: SELECT gen_object_id
885: INTO l_parent_object_id
886: FROM mtl_serial_numbers
887: WHERE inventory_item_id = l_assy_tbl(l_a_ind).inventory_item_id
888: AND serial_number = l_assy_tbl(l_a_ind).serial_number;
889:
890: FOR mog_rec in mog_cur (l_parent_object_id)

Line 2173: mtl_serial_numbers msn,

2169: --Changed for Bug 12636010
2170: SELECT msn.serial_number child_serial_number,
2171: msn.inventory_item_id child_item_id
2172: FROM mtl_object_genealogy mog,
2173: mtl_serial_numbers msn,
2174: mtl_system_items_b msib
2175: WHERE mog.parent_object_type = 2
2176: AND msib.inventory_item_id = msn.inventory_item_id
2177: AND msib.organization_id = msn.current_organization_id

Line 2209: FROM mtl_serial_numbers

2205: debug('Parent Serial :'||l_assy_tbl(l_ind).serial_number);
2206:
2207: SELECT gen_object_id
2208: INTO l_parent_object_id
2209: FROM mtl_serial_numbers
2210: WHERE inventory_item_id = l_assy_tbl(l_ind).inventory_item_id
2211: AND serial_number = l_assy_tbl(l_ind).serial_number;
2212:
2213: l_children_count := 0;

Line 2280: FROM mtl_serial_numbers

2276: SELECT gen_object_id,
2277: parent_serial_number
2278: INTO l_child_object_id,
2279: l_parent_serial_number
2280: FROM mtl_serial_numbers
2281: WHERE inventory_item_id = p_child_item_id
2282: and serial_number = p_child_serial_number;
2283: EXCEPTION
2284: WHEN NO_DATA_FOUND THEN

Line 2300: mtl_serial_numbers msn,

2296: msn.inventory_item_id
2297: INTO l_parent_serial_number,
2298: l_parent_item_id
2299: FROM mtl_object_genealogy mog,
2300: mtl_serial_numbers msn,
2301: mtl_system_items_b msib
2302: WHERE mog.object_type = 2 -- serial genealogy
2303: AND msib.inventory_item_id = msn.inventory_item_id
2304: AND msib.organization_id = msn.current_organization_id