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 542: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;

538: top_level_object_type_id = l_top_level_object_type_id
539: where sched_relationship_id = l_relationship_record.sched_relationship_id;
540:
541: select maintenance_object_source into l_maint_obj_src
542: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;
543: if l_maint_obj_src = 1 then -- EAM
544: update eam_wo_relationships set
545: top_level_object_id = l_top_level_object_id,
546: top_level_object_type_id = l_top_level_object_type_id

Line 626: wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;

622:
623: if l_relationship_record.parent_object_id is not null then
624:
625: select firm_planned_flag into l_parent_firm_flag from
626: wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;
627:
628: EXIT WHEN l_parent_firm_flag = 1;
629:
630: Adjust_Parent(

Line 775: from wip_discrete_jobs

771: if l_relationship_record.child_object_id is not null then
772:
773: select scheduled_start_date, scheduled_completion_date, status_type, date_completed
774: into l_wo_start_date, l_wo_end_date,l_status_type,l_date_completed
775: from wip_discrete_jobs
776: where wip_entity_id = l_relationship_record.child_object_id;
777:
778: --do not consider child workorders which are cancelled or [closed and date_completed is null](closed from cancelled status)
779: IF NOT(

Line 801: into l_wo_start_date, l_wo_end_date from wip_discrete_jobs

797:
798: CLOSE l_constrained_children;
799:
800: select scheduled_start_date, scheduled_completion_date
801: into l_wo_start_date, l_wo_end_date from wip_discrete_jobs
802: where wip_entity_id = l_relationship_record.parent_object_id;
803:
804: if l_wo_start_date > nvl(l_min_date, l_wo_start_date + 1) then
805: l_wo_start_date := l_min_date;

Line 811: UPDATE WIP_DISCRETE_JOBS set

807: if l_wo_end_date < nvl(l_max_date, l_wo_end_date - 1) then
808: l_wo_end_date := l_max_date;
809: end if;
810:
811: UPDATE WIP_DISCRETE_JOBS set
812: scheduled_start_date = l_wo_start_date,
813: scheduled_completion_date = l_wo_end_date
814: where wip_entity_id = l_parent_object_id;
815:

Line 1097: from wip_discrete_jobs where

1093: end if;
1094:
1095: -- Check that the prior work order is not completed
1096: select status_type into l_status_type
1097: from wip_discrete_jobs where
1098: wip_entity_id = l_prior_object_id;
1099: if l_status_type in (4,5,12,14,15) then
1100:
1101: l_token_tbl(1).token_name := 'Prior_WorkOrder';

Line 1332: from wip_discrete_jobs where

1328: select status_type, scheduled_start_date,
1329: scheduled_completion_date
1330: into l_status_type, l_prior_start_date,
1331: l_prior_completion_date
1332: from wip_discrete_jobs where
1333: wip_entity_id = l_prior_object_id;
1334: l_prior_status_type := l_status_type;
1335: if l_status_type in (4,5,12,14,15) then
1336:

Line 1360: from wip_discrete_jobs where

1356: select status_type, scheduled_start_date,
1357: scheduled_completion_date
1358: into l_status_type, l_next_start_date,
1359: l_next_completion_date
1360: from wip_discrete_jobs where
1361: wip_entity_id = l_next_object_id;
1362: l_next_status_type := l_status_type;
1363: if l_status_type in (4,5,12,14,15) then
1364:

Line 1792: wip_discrete_jobs where wip_entity_id = l_parent_object_id;

1788: end if;
1789:
1790: IF l_relationship_type = 1 THEN
1791: select firm_planned_flag into l_parent_firm_flag from
1792: wip_discrete_jobs where wip_entity_id = l_parent_object_id;
1793:
1794: IF(l_parent_firm_flag = 2) THEN
1795: Shrink_Parent(
1796: p_parent_object_id => l_parent_object_id,

Line 1817: wip_discrete_jobs where wip_entity_id = l_parent_record.parent_object_id;

1813:
1814: if l_parent_record.parent_object_id is not null then
1815:
1816: select firm_planned_flag into l_parent_firm_flag from
1817: wip_discrete_jobs where wip_entity_id = l_parent_record.parent_object_id;
1818:
1819: EXIT WHEN l_parent_firm_flag = 1;
1820:
1821: Shrink_Parent(

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

1856: top_level_object_type_id = l_child_object_type_id
1857: where sched_relationship_id = l_relationship_record.sched_relationship_id;
1858:
1859: select maintenance_object_source into l_maint_obj_src
1860: from wip_discrete_jobs where wip_entity_id = l_relationship_record.parent_object_id;
1861: if l_maint_obj_src = 1 then -- EAM
1862: update eam_wo_relationships set
1863: top_level_object_id = l_child_object_id,
1864: top_level_object_type_id = l_child_object_type_id

Line 1990: from wip_discrete_jobs

1986: BEGIN
1987:
1988: select scheduled_start_date, scheduled_completion_date
1989: into l_wo_start_date, l_wo_completion_date
1990: from wip_discrete_jobs
1991: where wip_entity_id = l_wip_entity_id and
1992: organization_id = l_organization_id;
1993:
1994:

Line 2197: from wip_discrete_jobs

2193: BEGIN
2194:
2195: select scheduled_start_date, scheduled_completion_date
2196: into l_wo_start_date, l_wo_completion_date
2197: from wip_discrete_jobs
2198: where wip_entity_id = l_wip_entity_id;
2199:
2200: -- find the list of wo operations
2201: IF NOT l_wo_operations%ISOPEN THEN

Line 2863: FROM WIP_DISCRETE_JOBS WDJ

2859: l_stmt_num := 20;
2860: BEGIN
2861: SELECT COUNT(WDJ.WIP_ENTITY_ID)
2862: INTO l_wo_in_planning
2863: FROM WIP_DISCRETE_JOBS WDJ
2864: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
2865: AND l_work_object_type_id = 1
2866: AND WDJ.STATUS_TYPE NOT IN (3,4,5,6,7,12,14,15);
2867: EXCEPTION

Line 2886: WIP_DISCRETE_JOBS WDJ1,

2882:
2883: SELECT (WDJ1.SCHEDULED_COMPLETION_DATE - WDJ2.SCHEDULED_COMPLETION_DATE)
2884: INTO l_this_level_min_window
2885: FROM WIP_SCHED_RELATIONSHIPS WSR,
2886: WIP_DISCRETE_JOBS WDJ1,
2887: WIP_DISCRETE_JOBS WDJ2
2888: WHERE WSR.CHILD_OBJECT_ID = l_work_object_id
2889: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id
2890: AND WSR.CHILD_OBJECT_TYPE_ID = 1

Line 2887: WIP_DISCRETE_JOBS WDJ2

2883: SELECT (WDJ1.SCHEDULED_COMPLETION_DATE - WDJ2.SCHEDULED_COMPLETION_DATE)
2884: INTO l_this_level_min_window
2885: FROM WIP_SCHED_RELATIONSHIPS WSR,
2886: WIP_DISCRETE_JOBS WDJ1,
2887: WIP_DISCRETE_JOBS WDJ2
2888: WHERE WSR.CHILD_OBJECT_ID = l_work_object_id
2889: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id
2890: AND WSR.CHILD_OBJECT_TYPE_ID = 1
2891: AND WSR.RELATIONSHIP_TYPE = 1

Line 2931: WIP_DISCRETE_JOBS WDJ1,

2927:
2928: SELECT MIN(WDJ2.SCHEDULED_START_DATE - WDJ1.SCHEDULED_COMPLETION_DATE)
2929: INTO l_min_right_snap_window
2930: FROM WIP_SCHED_RELATIONSHIPS WSR,
2931: WIP_DISCRETE_JOBS WDJ1,
2932: WIP_DISCRETE_JOBS WDJ2
2933: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
2934: AND WSR.CHILD_OBJECT_TYPE_ID = 1
2935: AND WSR.PARENT_OBJECT_ID = l_work_object_id

Line 2932: WIP_DISCRETE_JOBS WDJ2

2928: SELECT MIN(WDJ2.SCHEDULED_START_DATE - WDJ1.SCHEDULED_COMPLETION_DATE)
2929: INTO l_min_right_snap_window
2930: FROM WIP_SCHED_RELATIONSHIPS WSR,
2931: WIP_DISCRETE_JOBS WDJ1,
2932: WIP_DISCRETE_JOBS WDJ2
2933: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
2934: AND WSR.CHILD_OBJECT_TYPE_ID = 1
2935: AND WSR.PARENT_OBJECT_ID = l_work_object_id
2936: AND WSR.PARENT_OBJECT_TYPE_ID = l_work_object_type_id

Line 2985: FROM WIP_DISCRETE_JOBS WDJ

2981: l_stmt_num := 95;
2982:
2983: SELECT NVL(WDJ.MAINTENANCE_OBJECT_SOURCE,1)
2984: INTO l_maintenance_object_source
2985: FROM WIP_DISCRETE_JOBS WDJ
2986: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
2987: AND l_work_object_type_id = 1;
2988:
2989: IF (l_maintenance_object_source = 2) THEN -- ONLY for AHL Jobs

Line 3145: FROM WIP_DISCRETE_JOBS WDJ

3141: l_stmt_num := 20;
3142: BEGIN
3143: SELECT COUNT(WDJ.WIP_ENTITY_ID)
3144: INTO l_wo_in_planning
3145: FROM WIP_DISCRETE_JOBS WDJ
3146: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
3147: AND l_work_object_type_id = 1
3148: AND WDJ.STATUS_TYPE NOT IN (3,4,5,6,7,12,14,15);
3149: EXCEPTION

Line 3170: WIP_DISCRETE_JOBS WDJ1,

3166:
3167: SELECT (WDJ2.SCHEDULED_START_DATE - WDJ1.SCHEDULED_START_DATE)
3168: INTO l_this_level_min_window
3169: FROM WIP_SCHED_RELATIONSHIPS WSR,
3170: WIP_DISCRETE_JOBS WDJ1,
3171: WIP_DISCRETE_JOBS WDJ2
3172: WHERE WSR.CHILD_OBJECT_ID = l_work_object_id
3173: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id
3174: AND WSR.CHILD_OBJECT_TYPE_ID = 1

Line 3171: WIP_DISCRETE_JOBS WDJ2

3167: SELECT (WDJ2.SCHEDULED_START_DATE - WDJ1.SCHEDULED_START_DATE)
3168: INTO l_this_level_min_window
3169: FROM WIP_SCHED_RELATIONSHIPS WSR,
3170: WIP_DISCRETE_JOBS WDJ1,
3171: WIP_DISCRETE_JOBS WDJ2
3172: WHERE WSR.CHILD_OBJECT_ID = l_work_object_id
3173: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id
3174: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3175: AND WSR.RELATIONSHIP_TYPE = 1

Line 3214: WIP_DISCRETE_JOBS WDJ1,

3210:
3211: SELECT MIN(WDJ1.SCHEDULED_START_DATE - WDJ2.SCHEDULED_COMPLETION_DATE)
3212: INTO l_min_left_snap_window
3213: FROM WIP_SCHED_RELATIONSHIPS WSR,
3214: WIP_DISCRETE_JOBS WDJ1,
3215: WIP_DISCRETE_JOBS WDJ2
3216: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3217: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3218: AND WSR.CHILD_OBJECT_ID = l_work_object_id

Line 3215: WIP_DISCRETE_JOBS WDJ2

3211: SELECT MIN(WDJ1.SCHEDULED_START_DATE - WDJ2.SCHEDULED_COMPLETION_DATE)
3212: INTO l_min_left_snap_window
3213: FROM WIP_SCHED_RELATIONSHIPS WSR,
3214: WIP_DISCRETE_JOBS WDJ1,
3215: WIP_DISCRETE_JOBS WDJ2
3216: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3217: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3218: AND WSR.CHILD_OBJECT_ID = l_work_object_id
3219: AND WSR.CHILD_OBJECT_TYPE_ID = l_work_object_type_id

Line 3266: FROM WIP_DISCRETE_JOBS WDJ

3262: l_stmt_num := 95;
3263:
3264: SELECT NVL(WDJ.MAINTENANCE_OBJECT_SOURCE,1)
3265: INTO l_maintenance_object_source
3266: FROM WIP_DISCRETE_JOBS WDJ
3267: WHERE WDJ.WIP_ENTITY_ID = l_work_object_id
3268: AND l_work_object_type_id = 1;
3269:
3270: IF (l_maintenance_object_source = 2) THEN -- ONLY for AHL Jobs

Line 3459: WIP_DISCRETE_JOBS WDJ1,

3455: BEGIN
3456: SELECT MIN(WDJ2.SCHEDULED_START_DATE-WDJ1.SCHEDULED_COMPLETION_DATE)
3457: INTO l_min_right_snap_window
3458: FROM WIP_SCHED_RELATIONSHIPS WSR,
3459: WIP_DISCRETE_JOBS WDJ1,
3460: WIP_DISCRETE_JOBS WDJ2
3461: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3462: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3463: AND WSR.PARENT_OBJECT_ID = l_parent_object_id

Line 3460: WIP_DISCRETE_JOBS WDJ2

3456: SELECT MIN(WDJ2.SCHEDULED_START_DATE-WDJ1.SCHEDULED_COMPLETION_DATE)
3457: INTO l_min_right_snap_window
3458: FROM WIP_SCHED_RELATIONSHIPS WSR,
3459: WIP_DISCRETE_JOBS WDJ1,
3460: WIP_DISCRETE_JOBS WDJ2
3461: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3462: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3463: AND WSR.PARENT_OBJECT_ID = l_parent_object_id
3464: AND WSR.PARENT_OBJECT_TYPE_ID = l_parent_object_type_id

Line 3713: WIP_DISCRETE_JOBS WDJ1,

3709: BEGIN
3710: SELECT MIN(WDJ2.SCHEDULED_START_DATE-WDJ1.SCHEDULED_COMPLETION_DATE)
3711: INTO l_min_left_snap_window
3712: FROM WIP_SCHED_RELATIONSHIPS WSR,
3713: WIP_DISCRETE_JOBS WDJ1,
3714: WIP_DISCRETE_JOBS WDJ2
3715: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3716: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3717: AND WSR.CHILD_OBJECT_ID = l_parent_object_id

Line 3714: WIP_DISCRETE_JOBS WDJ2

3710: SELECT MIN(WDJ2.SCHEDULED_START_DATE-WDJ1.SCHEDULED_COMPLETION_DATE)
3711: INTO l_min_left_snap_window
3712: FROM WIP_SCHED_RELATIONSHIPS WSR,
3713: WIP_DISCRETE_JOBS WDJ1,
3714: WIP_DISCRETE_JOBS WDJ2
3715: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
3716: AND WSR.CHILD_OBJECT_TYPE_ID = 1
3717: AND WSR.CHILD_OBJECT_ID = l_parent_object_id
3718: AND WSR.CHILD_OBJECT_TYPE_ID = l_parent_object_type_id

Line 3901: from wip_discrete_jobs

3897: if l_relationship_record.child_object_id is not null then
3898:
3899: select scheduled_start_date, scheduled_completion_date, status_type, date_completed
3900: into l_wo_start_date, l_wo_end_date,l_status_type,l_date_completed
3901: from wip_discrete_jobs
3902: where wip_entity_id = l_relationship_record.child_object_id;
3903:
3904: --do not consider child workorders which are cancelled or [closed and date_completed is null](closed from cancelled status)
3905: IF NOT(

Line 3928: FROM WIP_DISCRETE_JOBS

3924: CLOSE l_constrained_children;
3925:
3926: SELECT requested_start_date,due_date
3927: INTO l_requested_start_date,l_requested_due_date
3928: FROM WIP_DISCRETE_JOBS
3929: WHERE wip_entity_id=l_parent_object_id;
3930:
3931: select min(first_unit_start_date),max(last_unit_completion_date)
3932: INTO l_op_start_date,l_op_end_date

Line 3956: UPDATE WIP_DISCRETE_JOBS set

3952: l_wo_end_date := l_op_end_date;
3953: END IF;
3954: END IF;
3955:
3956: UPDATE WIP_DISCRETE_JOBS set
3957: scheduled_start_date = l_wo_start_date,
3958: scheduled_completion_date = l_wo_end_date
3959: where wip_entity_id = l_parent_object_id;
3960: