DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on CST_QUANTITY_LAYERS

Line 6535: FROM mtl_cross_references_b mcr, cst_quantity_layers cql, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz

6531: AND cic.last_update_date >= l_from_date
6532: AND cic.last_update_date <= l_to_date
6533: UNION
6534: SELECT cql.inventory_item_id, msik.concatenated_segments, cql.organization_id, mp.organization_code
6535: FROM mtl_cross_references_b mcr, cst_quantity_layers cql, mtl_parameters mp, mtl_system_items_kfv msik, hz_orig_systems_b hz
6536: WHERE mcr.inventory_item_id = cql.inventory_item_id
6537: --AND mcr.organization_id = cql.organization_id
6538: AND msik.organization_id = mp.organization_id
6539: AND hz.orig_system IN (SELECT * FROM THE(SELECT CAST(l_parsed_tbl AS FND_TABLE_OF_VARCHAR2_255) FROM DUAL))

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

6564: AND cic.last_update_date >= l_from_date
6565: AND cic.last_update_date <= l_to_date
6566: UNION
6567: SELECT cql.inventory_item_id, msik.concatenated_segments, cql.organization_id, mp.organization_code
6568: FROM cst_quantity_layers cql,mtl_parameters mp, mtl_system_items_kfv msik
6569: WHERE cql.organization_id=mp.organization_id
6570: AND msik.organization_id = cql.organization_id
6571: AND msik.inventory_item_id = cql.inventory_item_id
6572: AND cql.last_update_date >= l_from_date