DBA Data[Home] [Help]

APPS.EAM_PM_UTILS dependencies on MTL_SYSTEM_ITEMS

Line 471: from mtl_system_items

467: end if;
468:
469: select eam_item_type
470: into l_eam_item_type
471: from mtl_system_items
472: where organization_id = l_org_id
473: and inventory_item_id = l_inventory_item_id;
474:
475: select description

Line 477: /* from mtl_system_items_b Commented for bug#4878157 */

473: and inventory_item_id = l_inventory_item_id;
474:
475: select description
476: into l_description
477: /* from mtl_system_items_b Commented for bug#4878157 */
478: from mtl_system_items_vl /* Added for bug#4878157 */
479: where inventory_item_id = l_asset_activity_id
480: and organization_id = l_org_id;
481:

Line 478: from mtl_system_items_vl /* Added for bug#4878157 */

474:
475: select description
476: into l_description
477: /* from mtl_system_items_b Commented for bug#4878157 */
478: from mtl_system_items_vl /* Added for bug#4878157 */
479: where inventory_item_id = l_asset_activity_id
480: and organization_id = l_org_id;
481:
482: open pmwo;