APPS.IBE_DSP_HIERARCHY_QUERY_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 149: FROM ibe_dsp_section_items SI, mtl_system_items_vl MTL, fnd_lookups L

145: OPEN x_sectionitem_item_csr FOR SELECT MTL.inventory_item_id,
146: MTL.organization_id, MTL.concatenated_segments, MTL.description,
147: MTL.web_status, L.meaning, SI.section_item_id, SI.object_version_number,
148: SI.start_date_active, SI.end_date_active, SI.sort_order
149: FROM ibe_dsp_section_items SI, mtl_system_items_vl MTL, fnd_lookups L
150: WHERE SI.section_id = p_section_id
151: AND SI.inventory_item_id = MTL.inventory_item_id
152: AND SI.organization_id = MTL.organization_id
153: AND L.lookup_type = 'IBE_ITEM_STATUS'

Line 978: FROM mtl_system_items_vl

974: -- Get the item data
975: OPEN x_inventory_item_csr FOR SELECT inventory_item_id, organization_id,
976: web_status, description, long_description, concatenated_segments,
977: creation_date, last_updated_by, last_update_login, last_update_date
978: FROM mtl_system_items_vl
979: WHERE inventory_item_id = p_inventory_item_id
980: AND organization_id = p_organization_id;
981:
982: -- Get the 'list of item web status type' cursor

Line 1083: FROM mtl_system_items_vl MTL, fnd_lookups L

1079: OPEN x_inventory_item_csr FOR SELECT MTL.inventory_item_id,
1080: MTL.organization_id, MTL.web_status, L.meaning, MTL.description,
1081: MTL.concatenated_segments, MTL.creation_date, MTL.last_updated_by,
1082: MTL.last_update_login, MTL.last_update_date
1083: FROM mtl_system_items_vl MTL, fnd_lookups L
1084: WHERE MTL.inventory_item_id = p_inventory_item_id
1085: AND MTL.organization_id = p_organization_id
1086: AND L.lookup_type = 'IBE_ITEM_STATUS'
1087: AND L.lookup_code = MTL.web_status;