DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on CST_ITEM_COSTS

Line 6522: FROM mtl_cross_references_b mcr, cst_item_costs cic,mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz

6518: AND msi.last_update_date >= l_from_date
6519: AND msi.last_update_date <= l_to_date
6520: UNION
6521: SELECT cic.inventory_item_id, msik.concatenated_segments, cic.organization_id, mp.organization_code
6522: FROM mtl_cross_references_b mcr, cst_item_costs cic,mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6523: WHERE mcr.inventory_item_id = cic.inventory_item_id
6524: --AND mcr.organization_id = cic.organization_id
6525: AND msik.organization_id = mp.organization_id
6526: AND msik.organization_id = cic.organization_id

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

6555: AND msi.last_update_date >= l_from_date
6556: AND msi.last_update_date <= l_to_date
6557: UNION
6558: SELECT cic.inventory_item_id, msik.concatenated_segments, cic.organization_id, mp.organization_code
6559: FROM cst_item_costs cic, mtl_parameters mp, mtl_system_items_kfv msik
6560: WHERE cic.organization_id = mp.organization_id
6561: AND msik.organization_id = cic.organization_id
6562: AND msik.inventory_item_id = cic.inventory_item_id
6563: AND cic.last_update_date <> cic.creation_date