DBA Data[Home] [Help]

APPS.MTL_CCEOI_PROCESS_PVT dependencies on MTL_ITEM_LOCATIONS

Line 64: FROM mtl_item_locations mil,

60: NVL ( p_cost_group_id , mp.default_cost_group_id)
61: )
62: UNION ALL
63: SELECT NVL ( ccicv.item_cost, 0 )
64: FROM mtl_item_locations mil,
65: cst_cg_item_costs_view ccicv,
66: mtl_parameters mp
67: WHERE l_locator_id IS NOT NULL
68: AND mil.organization_id = p_organization_id

Line 81: FROM mtl_item_locations mil,

77: NVL ( p_cost_group_id , mp.default_cost_group_id)
78: )
79: UNION ALL
80: SELECT NVL ( ccicv.item_cost, 0 )
81: FROM mtl_item_locations mil,
82: mrp_project_parameters mrp,
83: cst_cg_item_costs_view ccicv,
84: mtl_parameters mp
85: WHERE l_locator_id IS NOT NULL

Line 4241: L_table_name := 'MTL_ITEM_LOCATIONS_KFV';

4237: END IF;
4238: --
4239: IF x_errorcode >0 THEN
4240: IF x_errorcode = 10 THEN
4241: L_table_name := 'MTL_ITEM_LOCATIONS_KFV';
4242: L_message_name := 'INV_CCEOI_INVALID_LOC';
4243: L_column_name := 'INVENTORY_LOCATION_ID';
4244: ELSIF
4245: x_errorcode = 47 THEN