APPS.CONVERT_TEST dependencies on MTL_ONHAND_QUANTITIES

Line 825: from mtl_onhand_quantities

821: , subinventory_code
822: , locator_id
823: , project_id
824: , task_id
825: from mtl_onhand_quantities
826: where organization_id = l_organization_id
827: and cost_group_id is null;
828:
829: --/*

Line 864: l_table_name := 'mtl_onhand_quantities';

860: -- loop
861: -- l_organization_id := c2.organization_id;
862: -- */
863:
864: l_table_name := 'mtl_onhand_quantities';
865:
866: for c1 in moq_cursor(l_organization_id)
867: loop
868: /*

Line 941: update mtl_onhand_quantities

937: , p_organization_id => l_organization_id
938: , p_subinventory => l_subinventory_code);
939: END IF;
940:
941: update mtl_onhand_quantities
942: set
943: cost_group_id = l_cost_group_id
944: , project_id = v_project_id
945: , task_id = v_task_id

Line 974: update mtl_onhand_quantities

970: , p_subinventory => l_subinventory_code);
971: END IF;
972:
973: if (l_cost_group_id > 0) then
974: update mtl_onhand_quantities
975: set cost_group_id = l_cost_group_id
976: where rowid = l_rowid;
977:
978: end if;

Line 1006: l_return_err := 'mtl_onhand_quantities cost group upgrade:'|| l_msg_data;

1002:
1003: l_msg_data := replace(l_msg_data,chr(0),' ');
1004:
1005:
1006: l_return_err := 'mtl_onhand_quantities cost group upgrade:'|| l_msg_data;
1007:
1008: INS_ERROR( p_table_name => l_table_name,
1009: p_ROWID => l_rowid_info,
1010: p_org_id => l_organization_id,

Line 1030: l_return_err := 'mtl_onhand_quantities cost group upgrade:'|| l_msg_data;

1026: );
1027:
1028: l_msg_data := replace(l_msg_data,chr(0),' ');
1029:
1030: l_return_err := 'mtl_onhand_quantities cost group upgrade:'|| l_msg_data;
1031:
1032:
1033: INS_ERROR( p_table_name => l_table_name,
1034: p_ROWID => l_rowid_info,

Line 1060: l_return_err := 'mtl_onhand_quantities cost group upgrade:'||

1056: p_ROWID => l_rowid_info,
1057: p_org_id => l_organization_id,
1058: p_error_msg => l_msg_data,
1059: p_proc_name => l_procedure_name);
1060: l_return_err := 'mtl_onhand_quantities cost group upgrade:'||
1061: substr(sqlerrm,1,55);
1062: raise_application_error(-20000,l_return_err);
1063:
1064: end INVMOQSB;