DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on CST_QUANTITY_LAYERS

Line 4956: FROM mtl_cross_references_b mcr, cst_quantity_layers cql, mtl_parameters mp, mtl_system_items_kfv msik

4952: AND cic.last_update_date >= l_from_date
4953: AND cic.last_update_date <= l_to_date
4954: UNION
4955: SELECT cql.inventory_item_id, msik.concatenated_segments, cql.organization_id, mp.organization_code
4956: FROM mtl_cross_references_b mcr, cst_quantity_layers cql, mtl_parameters mp, mtl_system_items_kfv msik
4957: WHERE mcr.inventory_item_id = cql.inventory_item_id
4958: AND mcr.organization_id = cql.organization_id
4959: AND mcr.organization_id = mp.organization_id
4960: AND mcr.cross_reference_type = p_cross_reference_type

Line 4987: FROM cst_quantity_layers cql,mtl_parameters mp, mtl_system_items_kfv msik

4983: AND cic.last_update_date >= l_from_date
4984: AND cic.last_update_date <= l_to_date
4985: UNION
4986: SELECT cql.inventory_item_id, msik.concatenated_segments, cql.organization_id, mp.organization_code
4987: FROM cst_quantity_layers cql,mtl_parameters mp, mtl_system_items_kfv msik
4988: WHERE cql.organization_id=mp.organization_id
4989: AND msik.organization_id = cql.organization_id
4990: AND msik.inventory_item_id = cql.inventory_item_id
4991: AND cql.last_update_date >= l_from_date