DBA Data[Home] [Help]

APPS.MTL_CCEOI_PROCESS_PVT dependencies on CST_CG_ITEM_COSTS_VIEW

Line 51: FROM cst_cg_item_costs_view ccicv,

47:
48: BEGIN
49: SELECT NVL ( ccicv.item_cost, 0 )
50: INTO x_item_cost
51: FROM cst_cg_item_costs_view ccicv,
52: mtl_parameters mp
53: WHERE l_locator_id IS NULL
54: AND ccicv.organization_id = p_organization_id
55: AND ccicv.inventory_item_id = p_inventory_item_id

Line 65: cst_cg_item_costs_view ccicv,

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
69: AND mil.inventory_location_id = l_locator_id

Line 83: cst_cg_item_costs_view ccicv,

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
86: AND mil.organization_id = p_organization_id
87: AND mil.inventory_location_id = l_locator_id