DBA Data[Home] [Help]

APPS.EAM_ITEM_ACTIVITIES_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 720: FROM mtl_system_items_b msi, mtl_parameters mp

716: /* Template flag validation */
717: begin
718: SELECT msi.eam_item_type , msi.serial_number_control_code
719: INTO l_item_type , l_ser_num_ctrl_cd
720: FROM mtl_system_items_b msi, mtl_parameters mp
721: WHERE msi.organization_id = mp.organization_id
722: AND mp.maint_organization_id = nvl(l_org_id, mp.maint_organization_id)
723: AND msi.inventory_item_id = l_asset_group_id
724: AND rownum = 1;

Line 1299: FROM mtl_system_items_b msi, mtl_parameters mp

1295: begin
1296:
1297: SELECT msi.eam_item_type , msi.serial_number_control_code
1298: INTO l_item_type , l_ser_num_ctrl_cd
1299: FROM mtl_system_items_b msi, mtl_parameters mp
1300: WHERE msi.organization_id = mp.organization_id
1301: AND mp.maint_organization_id = nvl(l_org_id, mp.maint_organization_id)
1302: AND msi.inventory_item_id = l_asset_group_id
1303: AND rownum = 1;