DBA Data[Home] [Help]

APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_ITEM_LOCATIONS

Line 123: FROM mtl_item_locations mil,

119: NVL ( p_cost_group_id , mp.default_cost_group_id)
120: )
121: UNION ALL
122: SELECT NVL ( ccicv.item_cost, 0 )
123: FROM mtl_item_locations mil,
124: cst_cg_item_costs_view ccicv,
125: mtl_parameters mp
126: WHERE l_locator_id IS NOT NULL
127: AND mil.organization_id = p_organization_id

Line 140: FROM mtl_item_locations mil,

136: NVL ( p_cost_group_id , mp.default_cost_group_id)
137: )
138: UNION ALL
139: SELECT NVL ( ccicv.item_cost, 0 )
140: FROM mtl_item_locations mil,
141: mrp_project_parameters mrp,
142: cst_cg_item_costs_view ccicv,
143: mtl_parameters mp
144: WHERE l_locator_id IS NOT NULL

Line 4383: L_table_name := 'MTL_ITEM_LOCATIONS_KFV';

4379: END IF;
4380: --
4381: IF x_errorcode >0 THEN
4382: IF x_errorcode = 10 THEN
4383: L_table_name := 'MTL_ITEM_LOCATIONS_KFV';
4384: L_message_name := 'INV_CCEOI_INVALID_LOC';
4385: L_column_name := 'INVENTORY_LOCATION_ID';
4386: ELSIF
4387: x_errorcode = 47 THEN