APPS.EAM_WORKBENCH_TREE dependencies on WIP_DISCRETE_JOBS

Line 95: FROM wip_discrete_jobs

91: (select maintenance_object_id,maintenance_object_type
92: from eam_pm_schedulings where set_name_id = p_set_name_id )
93: ) )
94: AND EXISTS (SELECT 1
95: FROM wip_discrete_jobs
96: WHERE organization_id = p_org_id
97: AND maintenance_object_id = cii.instance_id) ;
98: IF (SQL%ROWCOUNT = 0) AND (l_count_first = 1) THEN
99: l_count_first := 1;

Line 136: FROM wip_discrete_jobs

132: AND mena.maintenance_object_id = cii.instance_id
133: AND cii.last_vld_organization_id = mp.organization_id
134: AND mp.maint_organization_id <> p_org_id
135: AND EXISTS (SELECT 1
136: FROM wip_discrete_jobs
137: WHERE organization_id = p_org_id
138: AND maintenance_object_id = cii.instance_id) ;
139: END IF;
140: IF (SQL%ROWCOUNT = 0) AND (l_count_first = 1) THEN

Line 179: FROM wip_discrete_jobs

175: AND mena.maintenance_object_id = cii.instance_id
176: AND cii.last_vld_organization_id = mp.organization_id
177: AND mp.maint_organization_id <> p_org_id
178: AND EXISTS (SELECT 1
179: FROM wip_discrete_jobs
180: WHERE organization_id = p_org_id
181: AND maintenance_object_id = cii.instance_id) ;
182: IF (SQL%ROWCOUNT = 0) AND (l_count_first = 1) THEN
183: l_count_first := 1;

Line 334: FROM wip_discrete_jobs

330: (select maintenance_object_id,maintenance_object_type
331: from eam_pm_schedulings where set_name_id = p_set_name_id )
332: ) )
333: AND EXISTS (SELECT 1
334: FROM wip_discrete_jobs
335: WHERE organization_id = p_org_id
336: AND maintenance_object_id = cii.instance_id) ;
337: IF (SQL%ROWCOUNT = 0) AND (l_count_first = 1) THEN
338: l_count_first := 1;

Line 372: FROM wip_discrete_jobs

368: FROM mtl_eam_network_assets mena, csi_item_instances cii, mtl_parameters mp
369: WHERE p_instance_id = mena.network_object_id AND mena.maintenance_object_id = cii.instance_id
370: AND cii.last_vld_organization_id = mp.organization_id AND mp.maint_organization_id <> p_org_id
371: AND EXISTS (SELECT 1
372: FROM wip_discrete_jobs
373: WHERE organization_id = p_org_id
374: AND maintenance_object_id = cii.instance_id) ;
375: IF (SQL%ROWCOUNT = 0) AND (l_count_first = 1) THEN
376: l_count_first := 1;

Line 411: FROM wip_discrete_jobs

407: WHERE ciin.serial_number = p_asset_number AND ciin.inventory_item_id = p_asset_group_id
408: AND ciin.instance_id = mena.network_object_id AND mena.maintenance_object_id = cii.instance_id
409: AND cii.last_vld_organization_id = mp.organization_id AND mp.maint_organization_id <> p_org_id
410: AND EXISTS (SELECT 1
411: FROM wip_discrete_jobs
412: WHERE organization_id = p_org_id
413: AND maintenance_object_id = cii.instance_id) ;
414: IF (SQL%ROWCOUNT = 0) AND (l_count_first = 1) THEN
415: l_count_first := 1;