DBA Data[Home] [Help]

APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_DO_CHECK_TEMP

Line 11442: FROM mtl_do_check_temp

11438: l_root_id_tmp NUMBER;
11439:
11440: CURSOR C1 is
11441: SELECT root_id
11442: FROM mtl_do_check_temp
11443: ORDER BY organization_id, inventory_item_id;
11444: BEGIN
11445:
11446: IF g_debug = 1 THEN

Line 11476: insert into mtl_do_check_temp

11472: end if;
11473: l_line_id := g_rootinfos(l_root_id).demand_source_line_id;
11474:
11475: --Now insert into temp table;
11476: insert into mtl_do_check_temp
11477: ( ROOT_ID
11478: ,ORGANIZATION_ID
11479: ,INVENTORY_ITEM_ID
11480: ,LOT_CONTROL

Line 13502: from mtl_do_check_temp;

13498:
13499:
13500: function do_check_release_locks return boolean IS
13501: cursor C1 is select organization_id,inventory_item_id
13502: from mtl_do_check_temp;
13503: l_return_status varchar2(1);
13504: l_msg_count number;
13505: l_msg_data varchar2(2000);
13506: l_api_number number := 1.0;