DBA Data[Home] [Help]

APPS.EAM_PM_UTILS dependencies on MTL_SYSTEM_ITEMS

Line 470: from mtl_system_items

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

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

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

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

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