APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on WIP_DISCRETE_JOBS

Line 328: FROM wip_discrete_jobs

324: IF p_wip_entity_id IS NULL THEN
325: RETURN NULL;
326: ELSE
327: SELECT primary_item_id INTO l_activity_id
328: FROM wip_discrete_jobs
329: WHERE wip_entity_id = p_wip_entity_id;
330:
331: RETURN l_activity_id;
332: END IF;

Line 367: FROM wip_discrete_jobs

363: IF p_wip_entity_id IS NULL THEN
364: RETURN NULL;
365: ELSE
366: SELECT organization_id INTO l_org_id
367: FROM wip_discrete_jobs
368: WHERE wip_entity_id = p_wip_entity_id;
369:
370: RETURN l_org_id;
371: END IF;

Line 531: FROM wip_discrete_jobs

527: RETURN;
528: ELSE
529: SELECT asset_group_id, asset_number
530: INTO x_inventory_item_id, x_serial_number
531: FROM wip_discrete_jobs
532: WHERE wip_entity_id = p_wip_entity_id;
533: END IF;
534:
535: EXCEPTION

Line 1120: FROM wip_discrete_jobs

1116: x_wo_maint_type := NULL;
1117: ELSE
1118: SELECT organization_id, primary_item_id, maintenance_object_id, maintenance_object_type
1119: INTO x_source_org_id, x_source_activity_id, x_wo_maint_id, x_wo_maint_type
1120: FROM wip_discrete_jobs
1121: WHERE wip_entity_id = p_wip_entity_id;
1122:
1123: END IF;
1124: