DBA Data[Home] [Help]

APPS.EAM_DOWNTIME_PUB dependencies on MTL_PARAMETERS

Line 63: mtl_parameters mp,

59: FROM wip_discrete_jobs wdj,
60: wip_entities we,
61: mtl_serial_numbers msn,
62: csi_item_instances cii,
63: mtl_parameters mp,
64: bom_resource_equipments bre,
65: bom_dept_res_instances bdri,
66: wip_operations wo
67: WHERE

Line 220: from mtl_parameters where organization_id=p_org_id;

216:
217:
218:
219: select calendar_code, calendar_exception_set_id into l_calendar_code, l_exception_set_id
220: from mtl_parameters where organization_id=p_org_id;
221:
222: l_stmt_num := 15;
223: SELECT bom_resource_downtime_group_s.nextval
224: INTO l_downtime_group_id