eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_WO_NETWORK_DEFAULT_PVT dependencies on WIP_DISCRETE_JOBS

Line 207: from wip_discrete_jobs where

203: -- Check that the parent_object_id and child_object_id are
204: -- valid wip_entity_id s. And if they are, then get their sources
205: begin
206: select status_type into l_child_status_type
207: from wip_discrete_jobs where
208: wip_entity_id = l_child_object_id;
209: exception
210: WHEN NO_DATA_FOUND THEN
211:

Line 232: from wip_discrete_jobs where

228: end;
229:
230: select maintenance_object_source into
231: l_child_maint_obj_src
232: from wip_discrete_jobs where
233: wip_entity_id = l_child_object_id;
234:
235:
236: begin

Line 238: from wip_discrete_jobs where

234:
235:
236: begin
237: select status_type into l_parent_status_type
238: from wip_discrete_jobs where
239: wip_entity_id = l_parent_object_id;
240:
241: exception
242: WHEN NO_DATA_FOUND THEN

Line 264: from wip_discrete_jobs where

260: end ;
261:
262: select maintenance_object_source, rebuild_item_id into
263: l_parent_maint_obj_src, l_rebuild_item_id
264: from wip_discrete_jobs where
265: wip_entity_id = l_parent_object_id;
266:
267:
268: if l_parent_maint_obj_src <> l_child_maint_obj_src then

Line 546: from wip_discrete_jobs where wip_entity_id = l_parent_object_id;

542: where sched_relationship_id = l_sched_relationship_id;
543:
544:
545: select maintenance_object_source into l_maint_obj_src
546: from wip_discrete_jobs where wip_entity_id = l_parent_object_id;
547:
548: -- test_mesg('after update wip_sched_relationships sched rel id '||l_sched_relationship_id||' l_parent_object_id ' ||l_parent_object_id ||' l_child_object_id '||l_child_object_id );
549: if l_maint_obj_src = 1 then -- EAM
550:

Line 564: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;*/

560: top_level_object_type_id = l_top_level_object_type_id
561: where sched_relationship_id = l_relationship_record.sched_relationship_id;
562:
563: select maintenance_object_source into l_maint_obj_src
564: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;*/
565:
566: update eam_wo_relationships set
567: top_level_object_id = l_top_level_object_id,
568: top_level_object_type_id = l_top_level_object_type_id

Line 648: wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;

644:
645: if l_relationship_record.parent_object_id is not null then
646:
647: select firm_planned_flag into l_parent_firm_flag from
648: wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;
649:
650: EXIT WHEN l_parent_firm_flag = 1;
651:
652: Adjust_Parent(

Line 801: from wip_discrete_jobs

797: if l_relationship_record.child_object_id is not null then
798:
799: select scheduled_start_date, scheduled_completion_date, status_type, date_completed
800: into l_wo_start_date, l_wo_end_date,l_status_type,l_date_completed
801: from wip_discrete_jobs
802: where wip_entity_id = l_relationship_record.child_object_id;
803:
804: --do not consider child workorders which are cancelled or [closed and date_completed is null](closed from cancelled status)
805: IF NOT(

Line 827: into l_wo_start_date, l_wo_end_date from wip_discrete_jobs

823:
824: CLOSE l_constrained_children;
825:
826: select scheduled_start_date, scheduled_completion_date
827: into l_wo_start_date, l_wo_end_date from wip_discrete_jobs
828: where wip_entity_id = l_relationship_record.parent_object_id;
829:
830: if l_wo_start_date > nvl(l_min_date, l_wo_start_date + 1) then
831: l_wo_start_date := l_min_date;

Line 837: UPDATE WIP_DISCRETE_JOBS set

833: if l_wo_end_date < nvl(l_max_date, l_wo_end_date - 1) then
834: l_wo_end_date := l_max_date;
835: end if;
836:
837: UPDATE WIP_DISCRETE_JOBS set
838: scheduled_start_date = l_wo_start_date,
839: scheduled_completion_date = l_wo_end_date
840: where wip_entity_id = l_parent_object_id;
841:

Line 1123: from wip_discrete_jobs where

1119: end if;
1120:
1121: -- Check that the prior work order is not completed
1122: select status_type into l_status_type
1123: from wip_discrete_jobs where
1124: wip_entity_id = l_prior_object_id;
1125: if l_status_type in (4,5,12,14,15) then
1126:
1127: l_token_tbl(1).token_name := 'Prior_WorkOrder';

Line 1358: from wip_discrete_jobs where

1354: select status_type, scheduled_start_date,
1355: scheduled_completion_date
1356: into l_status_type, l_prior_start_date,
1357: l_prior_completion_date
1358: from wip_discrete_jobs where
1359: wip_entity_id = l_prior_object_id;
1360: l_prior_status_type := l_status_type;
1361: if l_status_type in (4,5,12,14,15) then
1362:

Line 1386: from wip_discrete_jobs where

1382: select status_type, scheduled_start_date,
1383: scheduled_completion_date
1384: into l_status_type, l_next_start_date,
1385: l_next_completion_date
1386: from wip_discrete_jobs where
1387: wip_entity_id = l_next_object_id;
1388: l_next_status_type := l_status_type;
1389: if l_status_type in (4,5,12,14,15) then
1390:

Line 1818: wip_discrete_jobs where wip_entity_id = l_parent_object_id;

1814: end if;
1815:
1816: IF l_relationship_type = 1 THEN
1817: select firm_planned_flag into l_parent_firm_flag from
1818: wip_discrete_jobs where wip_entity_id = l_parent_object_id;
1819:
1820: IF(l_parent_firm_flag = 2) THEN
1821: Shrink_Parent(
1822: p_parent_object_id => l_parent_object_id,

Line 1843: wip_discrete_jobs where wip_entity_id = l_parent_record.parent_object_id;

1839:
1840: if l_parent_record.parent_object_id is not null then
1841:
1842: select firm_planned_flag into l_parent_firm_flag from
1843: wip_discrete_jobs where wip_entity_id = l_parent_record.parent_object_id;
1844:
1845: EXIT WHEN l_parent_firm_flag = 1;
1846:
1847: Shrink_Parent(

Line 1887: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;

1883: top_level_object_type_id = l_child_object_type_id
1884: where sched_relationship_id = l_relationship_record.sched_relationship_id;
1885:
1886: select maintenance_object_source into l_maint_obj_src
1887: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;
1888: if l_maint_obj_src = 1 then -- EAM
1889: update eam_wo_relationships set
1890: top_level_object_id = l_child_object_id,
1891: top_level_object_type_id = l_child_object_type_id

Line 2017: from wip_discrete_jobs

2013: BEGIN
2014:
2015: select scheduled_start_date, scheduled_completion_date
2016: into l_wo_start_date, l_wo_completion_date
2017: from wip_discrete_jobs
2018: where wip_entity_id = l_wip_entity_id and
2019: organization_id = l_organization_id;
2020:
2021:

Line 2224: from wip_discrete_jobs

2220: BEGIN
2221:
2222: select scheduled_start_date, scheduled_completion_date
2223: into l_wo_start_date, l_wo_completion_date
2224: from wip_discrete_jobs
2225: where wip_entity_id = l_wip_entity_id;
2226:
2227: -- find the list of wo operations
2228: IF NOT l_wo_operations%ISOPEN THEN

Line 2890: FROM WIP_DISCRETE_JOBS WDJ

2886: l_stmt_num := 20;
2887: BEGIN
2888: SELECT COUNT(WDJ.WIP_ENTITY_ID)
2889: INTO l_wo_in_planning
2890: FROM WIP_DISCRETE_JOBS WDJ
2891: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
2892: AND l_work_object_type_id = 1
2893: AND WDJ.STATUS_TYPE NOT IN (3,4,5,6,7,12,14,15);
2894: EXCEPTION

Line 2913: WIP_DISCRETE_JOBS WDJ1,

2909:
2910: SELECT (WDJ1.SCHEDULED_COMPLETION_DATE - WDJ2.SCHEDULED_COMPLETION_DATE)
2911: INTO l_this_level_min_window
2912: FROM WIP_SCHED_RELATIONSHIPS WSR,
2913: WIP_DISCRETE_JOBS WDJ1,
2914: WIP_DISCRETE_JOBS WDJ2
2915: WHERE WSR.CHILD_OBJECT_ID = l_work_object_id
2916: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id
2917: AND WSR.CHILD_OBJECT_TYPE_ID = 1

Line 2914: WIP_DISCRETE_JOBS WDJ2

2910: SELECT (WDJ1.SCHEDULED_COMPLETION_DATE - WDJ2.SCHEDULED_COMPLETION_DATE)
2911: INTO l_this_level_min_window
2912: FROM WIP_SCHED_RELATIONSHIPS WSR,
2913: WIP_DISCRETE_JOBS WDJ1,
2914: WIP_DISCRETE_JOBS WDJ2
2915: WHERE WSR.CHILD_OBJECT_ID = l_work_object_id
2916: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id
2917: AND WSR.CHILD_OBJECT_TYPE_ID = 1
2918: AND WSR.RELATIONSHIP_TYPE = 1

Line 2958: WIP_DISCRETE_JOBS WDJ1,

2954:
2955: SELECT MIN(WDJ2.SCHEDULED_START_DATE - WDJ1.SCHEDULED_COMPLETION_DATE)
2956: INTO l_min_right_snap_window
2957: FROM WIP_SCHED_RELATIONSHIPS WSR,
2958: WIP_DISCRETE_JOBS WDJ1,
2959: WIP_DISCRETE_JOBS WDJ2
2960: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
2961: AND WSR.CHILD_OBJECT_TYPE_ID = 1
2962: AND WSR.PARENT_OBJECT_ID = l_work_object_id

Line 2959: WIP_DISCRETE_JOBS WDJ2

2955: SELECT MIN(WDJ2.SCHEDULED_START_DATE - WDJ1.SCHEDULED_COMPLETION_DATE)
2956: INTO l_min_right_snap_window
2957: FROM WIP_SCHED_RELATIONSHIPS WSR,
2958: WIP_DISCRETE_JOBS WDJ1,
2959: WIP_DISCRETE_JOBS WDJ2
2960: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
2961: AND WSR.CHILD_OBJECT_TYPE_ID = 1
2962: AND WSR.PARENT_OBJECT_ID = l_work_object_id
2963: AND WSR.PARENT_OBJECT_TYPE_ID = l_work_object_type_id

Line 3012: FROM WIP_DISCRETE_JOBS WDJ

3008: l_stmt_num := 95;
3009:
3010: SELECT NVL(WDJ.MAINTENANCE_OBJECT_SOURCE,1)
3011: INTO l_maintenance_object_source
3012: FROM WIP_DISCRETE_JOBS WDJ
3013: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
3014: AND l_work_object_type_id = 1;
3015:
3016: IF (l_maintenance_object_source = 2) THEN -- ONLY for AHL Jobs

Line 3172: FROM WIP_DISCRETE_JOBS WDJ

3168: l_stmt_num := 20;
3169: BEGIN
3170: SELECT COUNT(WDJ.WIP_ENTITY_ID)
3171: INTO l_wo_in_planning
3172: FROM WIP_DISCRETE_JOBS WDJ
3173: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
3174: AND l_work_object_type_id = 1
3175: AND WDJ.STATUS_TYPE NOT IN (3,4,5,6,7,12,14,15);
3176: EXCEPTION

Line 3197: WIP_DISCRETE_JOBS WDJ1,

3193:
3194: SELECT (WDJ2.SCHEDULED_START_DATE - WDJ1.SCHEDULED_START_DATE)
3195: INTO l_this_level_min_window
3196: FROM WIP_SCHED_RELATIONSHIPS WSR,
3197: WIP_DISCRETE_JOBS WDJ1,
3198: WIP_DISCRETE_JOBS WDJ2
3199: WHERE WSR.CHILD_OBJECT_ID = l_work_object_id
3200: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id
3201: AND WSR.CHILD_OBJECT_TYPE_ID = 1

Line 3198: WIP_DISCRETE_JOBS WDJ2

3194: SELECT (WDJ2.SCHEDULED_START_DATE - WDJ1.SCHEDULED_START_DATE)
3195: INTO l_this_level_min_window
3196: FROM WIP_SCHED_RELATIONSHIPS WSR,
3197: WIP_DISCRETE_JOBS WDJ1,
3198: WIP_DISCRETE_JOBS WDJ2
3199: WHERE WSR.CHILD_OBJECT_ID = l_work_object_id
3200: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id
3201: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3202: AND WSR.RELATIONSHIP_TYPE = 1

Line 3241: WIP_DISCRETE_JOBS WDJ1,

3237:
3238: SELECT MIN(WDJ1.SCHEDULED_START_DATE - WDJ2.SCHEDULED_COMPLETION_DATE)
3239: INTO l_min_left_snap_window
3240: FROM WIP_SCHED_RELATIONSHIPS WSR,
3241: WIP_DISCRETE_JOBS WDJ1,
3242: WIP_DISCRETE_JOBS WDJ2
3243: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3244: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3245: AND WSR.CHILD_OBJECT_ID = l_work_object_id

Line 3242: WIP_DISCRETE_JOBS WDJ2

3238: SELECT MIN(WDJ1.SCHEDULED_START_DATE - WDJ2.SCHEDULED_COMPLETION_DATE)
3239: INTO l_min_left_snap_window
3240: FROM WIP_SCHED_RELATIONSHIPS WSR,
3241: WIP_DISCRETE_JOBS WDJ1,
3242: WIP_DISCRETE_JOBS WDJ2
3243: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3244: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3245: AND WSR.CHILD_OBJECT_ID = l_work_object_id
3246: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id

Line 3293: FROM WIP_DISCRETE_JOBS WDJ

3289: l_stmt_num := 95;
3290:
3291: SELECT NVL(WDJ.MAINTENANCE_OBJECT_SOURCE,1)
3292: INTO l_maintenance_object_source
3293: FROM WIP_DISCRETE_JOBS WDJ
3294: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
3295: AND l_work_object_type_id = 1;
3296:
3297: IF (l_maintenance_object_source = 2) THEN -- ONLY for AHL Jobs

Line 3486: WIP_DISCRETE_JOBS WDJ1,

3482: BEGIN
3483: SELECT MIN(WDJ2.SCHEDULED_START_DATE-WDJ1.SCHEDULED_COMPLETION_DATE)
3484: INTO l_min_right_snap_window
3485: FROM WIP_SCHED_RELATIONSHIPS WSR,
3486: WIP_DISCRETE_JOBS WDJ1,
3487: WIP_DISCRETE_JOBS WDJ2
3488: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3489: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3490: AND WSR.PARENT_OBJECT_ID = l_parent_object_id

Line 3487: WIP_DISCRETE_JOBS WDJ2

3483: SELECT MIN(WDJ2.SCHEDULED_START_DATE-WDJ1.SCHEDULED_COMPLETION_DATE)
3484: INTO l_min_right_snap_window
3485: FROM WIP_SCHED_RELATIONSHIPS WSR,
3486: WIP_DISCRETE_JOBS WDJ1,
3487: WIP_DISCRETE_JOBS WDJ2
3488: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3489: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3490: AND WSR.PARENT_OBJECT_ID = l_parent_object_id
3491: AND WSR.PARENT_OBJECT_TYPE_ID = l_parent_object_type_id

Line 3740: WIP_DISCRETE_JOBS WDJ1,

3736: BEGIN
3737: SELECT MIN(WDJ2.SCHEDULED_START_DATE-WDJ1.SCHEDULED_COMPLETION_DATE)
3738: INTO l_min_left_snap_window
3739: FROM WIP_SCHED_RELATIONSHIPS WSR,
3740: WIP_DISCRETE_JOBS WDJ1,
3741: WIP_DISCRETE_JOBS WDJ2
3742: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3743: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3744: AND WSR.CHILD_OBJECT_ID = l_parent_object_id

Line 3741: WIP_DISCRETE_JOBS WDJ2

3737: SELECT MIN(WDJ2.SCHEDULED_START_DATE-WDJ1.SCHEDULED_COMPLETION_DATE)
3738: INTO l_min_left_snap_window
3739: FROM WIP_SCHED_RELATIONSHIPS WSR,
3740: WIP_DISCRETE_JOBS WDJ1,
3741: WIP_DISCRETE_JOBS WDJ2
3742: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3743: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3744: AND WSR.CHILD_OBJECT_ID = l_parent_object_id
3745: AND WSR.CHILD_OBJECT_TYPE_ID = l_parent_object_type_id

Line 3928: from wip_discrete_jobs

3924: if l_relationship_record.child_object_id is not null then
3925:
3926: select scheduled_start_date, scheduled_completion_date, status_type, date_completed
3927: into l_wo_start_date, l_wo_end_date,l_status_type,l_date_completed
3928: from wip_discrete_jobs
3929: where wip_entity_id = l_relationship_record.child_object_id;
3930:
3931: --do not consider child workorders which are cancelled or [closed and date_completed is null](closed from cancelled status)
3932: IF NOT(

Line 3955: FROM WIP_DISCRETE_JOBS

3951: CLOSE l_constrained_children;
3952:
3953: SELECT requested_start_date,due_date
3954: INTO l_requested_start_date,l_requested_due_date
3955: FROM WIP_DISCRETE_JOBS
3956: WHERE wip_entity_id=l_parent_object_id;
3957:
3958: select min(first_unit_start_date),max(last_unit_completion_date)
3959: INTO l_op_start_date,l_op_end_date

Line 3983: UPDATE WIP_DISCRETE_JOBS set

3979: l_wo_end_date := l_op_end_date;
3980: END IF;
3981: END IF;
3982:
3983: UPDATE WIP_DISCRETE_JOBS set
3984: scheduled_start_date = l_wo_start_date,
3985: scheduled_completion_date = l_wo_end_date
3986: where wip_entity_id = l_parent_object_id;
3987: