DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on CST_ITEM_COSTS

Line 4944: FROM mtl_cross_references_b mcr, cst_item_costs cic,mtl_parameters mp, mtl_system_items_kfv msik

4940: AND msi.last_update_date >= l_from_date
4941: AND msi.last_update_date <= l_to_date
4942: UNION
4943: SELECT cic.inventory_item_id, msik.concatenated_segments, cic.organization_id, mp.organization_code
4944: FROM mtl_cross_references_b mcr, cst_item_costs cic,mtl_parameters mp, mtl_system_items_kfv msik
4945: WHERE mcr.inventory_item_id = cic.inventory_item_id
4946: AND mcr.organization_id = cic.organization_id
4947: AND mcr.organization_id = mp.organization_id
4948: AND msik.organization_id = cic.organization_id

Line 4978: FROM cst_item_costs cic, mtl_parameters mp, mtl_system_items_kfv msik

4974: AND msi.last_update_date <> msi.creation_date
4975: AND msi.last_update_date >= l_from_date AND msi.last_update_date <= l_to_date
4976: UNION
4977: SELECT cic.inventory_item_id, msik.concatenated_segments, cic.organization_id, mp.organization_code
4978: FROM cst_item_costs cic, mtl_parameters mp, mtl_system_items_kfv msik
4979: WHERE cic.organization_id = mp.organization_id
4980: AND msik.organization_id = cic.organization_id
4981: AND msik.inventory_item_id = cic.inventory_item_id
4982: AND cic.last_update_date <> cic.creation_date