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_VALIDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 91: WIP_DISCRETE_JOBS WDJ1,

87: WDJ2.SCHEDULED_COMPLETION_DATE AS CHILD_COMPLETION_DATE
88: FROM WIP_SCHED_RELATIONSHIPS WSR,
89: WIP_ENTITIES WE1,
90: WIP_ENTITIES WE2,
91: WIP_DISCRETE_JOBS WDJ1,
92: WIP_DISCRETE_JOBS WDJ2
93: WHERE WSR.RELATIONSHIP_STATUS = 3
94: AND WSR.RELATIONSHIP_TYPE = l_relationship_type
95: AND WSR.PARENT_OBJECT_TYPE_ID = 1

Line 92: WIP_DISCRETE_JOBS WDJ2

88: FROM WIP_SCHED_RELATIONSHIPS WSR,
89: WIP_ENTITIES WE1,
90: WIP_ENTITIES WE2,
91: WIP_DISCRETE_JOBS WDJ1,
92: WIP_DISCRETE_JOBS WDJ2
93: WHERE WSR.RELATIONSHIP_STATUS = 3
94: AND WSR.RELATIONSHIP_TYPE = l_relationship_type
95: AND WSR.PARENT_OBJECT_TYPE_ID = 1
96: AND WSR.CHILD_OBJECT_TYPE_ID = 1

Line 183: WIP_DISCRETE_JOBS WDJ1,

179: WHERE WSR.SCHED_RELATIONSHIP_ID IN
180: (
181: SELECT WSR1.SCHED_RELATIONSHIP_ID
182: FROM WIP_SCHED_RELATIONSHIPS WSR1,
183: WIP_DISCRETE_JOBS WDJ1,
184: WIP_DISCRETE_JOBS WDJ2
185: WHERE WSR1.PARENT_OBJECT_TYPE_ID = 1
186: AND WSR1.CHILD_OBJECT_TYPE_ID = 1
187: AND WDJ1.WIP_ENTITY_ID = WSR1.PARENT_OBJECT_ID

Line 184: WIP_DISCRETE_JOBS WDJ2

180: (
181: SELECT WSR1.SCHED_RELATIONSHIP_ID
182: FROM WIP_SCHED_RELATIONSHIPS WSR1,
183: WIP_DISCRETE_JOBS WDJ1,
184: WIP_DISCRETE_JOBS WDJ2
185: WHERE WSR1.PARENT_OBJECT_TYPE_ID = 1
186: AND WSR1.CHILD_OBJECT_TYPE_ID = 1
187: AND WDJ1.WIP_ENTITY_ID = WSR1.PARENT_OBJECT_ID
188: AND WDJ2.WIP_ENTITY_ID = WSR1.CHILD_OBJECT_ID

Line 201: WIP_DISCRETE_JOBS WDJ1,

197: WHERE EWR.WO_RELATIONSHIP_ID IN
198: (
199: SELECT EWR1.WO_RELATIONSHIP_ID
200: FROM EAM_WO_RELATIONSHIPS EWR1,
201: WIP_DISCRETE_JOBS WDJ1,
202: WIP_DISCRETE_JOBS WDJ2
203: WHERE EWR1.PARENT_OBJECT_TYPE_ID = 1
204: AND EWR1.CHILD_OBJECT_TYPE_ID = 1
205: AND WDJ1.WIP_ENTITY_ID = EWR1.PARENT_OBJECT_ID

Line 202: WIP_DISCRETE_JOBS WDJ2

198: (
199: SELECT EWR1.WO_RELATIONSHIP_ID
200: FROM EAM_WO_RELATIONSHIPS EWR1,
201: WIP_DISCRETE_JOBS WDJ1,
202: WIP_DISCRETE_JOBS WDJ2
203: WHERE EWR1.PARENT_OBJECT_TYPE_ID = 1
204: AND EWR1.CHILD_OBJECT_TYPE_ID = 1
205: AND WDJ1.WIP_ENTITY_ID = EWR1.PARENT_OBJECT_ID
206: AND WDJ2.WIP_ENTITY_ID = EWR1.CHILD_OBJECT_ID

Line 229: WIP_DISCRETE_JOBS WDJ

225:
226: SELECT COUNT(WSR.SCHED_RELATIONSHIP_ID)
227: INTO l_released_rowcount
228: FROM WIP_SCHED_RELATIONSHIPS WSR,
229: WIP_DISCRETE_JOBS WDJ
230: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
231: AND WSR.CHILD_OBJECT_TYPE_ID = 1
232: AND WDJ.WIP_ENTITY_ID = WSR.CHILD_OBJECT_ID
233: AND WDJ.STATUS_TYPE IN (3,4,5,6,7,12,14,15)

Line 724: WIP_DISCRETE_JOBS WDJ1,

720: WHERE WSR.SCHED_RELATIONSHIP_ID IN
721: (
722: SELECT WSR1.SCHED_RELATIONSHIP_ID
723: FROM WIP_SCHED_RELATIONSHIPS WSR1,
724: WIP_DISCRETE_JOBS WDJ1,
725: WIP_DISCRETE_JOBS WDJ2
726: WHERE WSR1.CHILD_OBJECT_TYPE_ID = child.child_object_type_id
727: AND WSR1.CHILD_OBJECT_ID = child.child_object_id
728: AND WSR1.PARENT_OBJECT_ID = l_parent_object_id

Line 725: WIP_DISCRETE_JOBS WDJ2

721: (
722: SELECT WSR1.SCHED_RELATIONSHIP_ID
723: FROM WIP_SCHED_RELATIONSHIPS WSR1,
724: WIP_DISCRETE_JOBS WDJ1,
725: WIP_DISCRETE_JOBS WDJ2
726: WHERE WSR1.CHILD_OBJECT_TYPE_ID = child.child_object_type_id
727: AND WSR1.CHILD_OBJECT_ID = child.child_object_id
728: AND WSR1.PARENT_OBJECT_ID = l_parent_object_id
729: AND WSR1.PARENT_OBJECT_TYPE_ID = l_parent_object_type_id

Line 751: WIP_DISCRETE_JOBS WDJ1,

747: WHERE EWR.WO_RELATIONSHIP_ID IN
748: (
749: SELECT EWR1.WO_RELATIONSHIP_ID
750: FROM EAM_WO_RELATIONSHIPS EWR1,
751: WIP_DISCRETE_JOBS WDJ1,
752: WIP_DISCRETE_JOBS WDJ2
753: WHERE EWR1.CHILD_OBJECT_TYPE_ID = child.child_object_type_id
754: AND EWR1.CHILD_OBJECT_ID = child.child_object_id
755: AND EWR1.PARENT_OBJECT_ID = l_parent_object_id

Line 752: WIP_DISCRETE_JOBS WDJ2

748: (
749: SELECT EWR1.WO_RELATIONSHIP_ID
750: FROM EAM_WO_RELATIONSHIPS EWR1,
751: WIP_DISCRETE_JOBS WDJ1,
752: WIP_DISCRETE_JOBS WDJ2
753: WHERE EWR1.CHILD_OBJECT_TYPE_ID = child.child_object_type_id
754: AND EWR1.CHILD_OBJECT_ID = child.child_object_id
755: AND EWR1.PARENT_OBJECT_ID = l_parent_object_id
756: AND EWR1.PARENT_OBJECT_TYPE_ID = l_parent_object_type_id

Line 788: WIP_DISCRETE_JOBS WDJ

784:
785: SELECT COUNT(SCHED_RELATIONSHIP_ID)
786: INTO l_released_rowcount
787: FROM WIP_SCHED_RELATIONSHIPS WSR,
788: WIP_DISCRETE_JOBS WDJ
789: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
790: AND WSR.CHILD_OBJECT_TYPE_ID = 1
791: AND WSR.PARENT_OBJECT_ID = l_parent_object_id
792: AND WSR.PARENT_OBJECT_TYPE_ID = l_parent_object_type_id

Line 916: FROM wip_discrete_jobs wdj,eam_work_order_details_v ewod

912: --Bug #5350181 :Changed the query to capture pending flag and user defined status
913:
914: SELECT wdj.status_type,ewod.user_defined_status_id,ewod.pending_flag
915: INTO l_wo_status,l_user_defined_status,l_pending_flag
916: FROM wip_discrete_jobs wdj,eam_work_order_details_v ewod
917: WHERE wdj.wip_entity_id=p_work_object_id
918: and ewod.wip_entity_id=wdj.wip_entity_id;
919:
920: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('workorder status'||l_wo_status); END IF;

Line 925: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

921:
922: BEGIN
923: SELECT wdj.status_type
924: INTO l_parent_status
925: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
926: WHERE wsr.child_object_id =p_work_object_id
927: and wsr.child_object_type_id = p_work_object_type_id
928: and wsr.relationship_type = 1
929: and wdj.wip_entity_id = wsr.parent_object_id;

Line 957: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

953:
954: IF(l_wo_status=17) THEN
955: SELECT COUNT(*)
956: INTO l_invalid_child
957: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
958: WHERE wsr.parent_object_id=p_work_object_id
959: AND wsr.parent_object_type_id= p_work_object_type_id
960: AND wsr.child_object_type_id=p_work_object_type_id
961: AND wsr.child_object_id=wdj.wip_entity_id

Line 967: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

963: AND wdj.status_type NOT IN (17,7,6);
964: ELSIF(l_wo_status=1) THEN
965: SELECT COUNT(*)
966: INTO l_invalid_child
967: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
968: WHERE wsr.parent_object_id=p_work_object_id
969: AND wsr.parent_object_type_id= p_work_object_type_id
970: AND wsr.child_object_type_id=p_work_object_type_id
971: AND wsr.child_object_id=wdj.wip_entity_id

Line 977: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

973: AND wdj.status_type NOT IN (17,7,1,6);
974: ELSIF(l_wo_status IN (3,6)) THEN
975: SELECT COUNT(*)
976: INTO l_invalid_child
977: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
978: WHERE wsr.parent_object_id=p_work_object_id
979: AND wsr.parent_object_type_id= p_work_object_type_id
980: AND wsr.child_object_type_id=p_work_object_type_id
981: AND wsr.child_object_id=wdj.wip_entity_id

Line 987: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

983: AND wdj.status_type NOT IN (3,6,17,7,1,12,14,15,4,5);
984: ELSIF(l_wo_status=7) THEN
985: SELECT COUNT(*)
986: INTO l_invalid_child
987: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
988: WHERE wsr.parent_object_id=p_work_object_id
989: AND wsr.parent_object_type_id= p_work_object_type_id
990: AND wsr.child_object_type_id=p_work_object_type_id
991: AND wsr.child_object_id=wdj.wip_entity_id

Line 997: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

993: AND wdj.status_type NOT IN (7,12,14,15);
994: ELSIF(l_wo_status IN (4,5,12,14,15)) THEN
995: SELECT COUNT(*)
996: INTO l_invalid_child
997: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
998: WHERE wsr.parent_object_id=p_work_object_id
999: AND wsr.parent_object_type_id= p_work_object_type_id
1000: AND wsr.child_object_type_id=p_work_object_type_id
1001: AND wsr.child_object_id=wdj.wip_entity_id

Line 1059: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1055:
1056: IF(l_wo_status=17) THEN
1057: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1058: l_WipEntityId_tbl,l_workorder_status_tbl
1059: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1060: WHERE wsr.parent_object_id=p_work_object_id
1061: AND wsr.parent_object_type_id= p_work_object_type_id
1062: AND wsr.child_object_type_id=p_work_object_type_id
1063: AND wsr.child_object_id=wdj.wip_entity_id

Line 1071: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1067: AND lk.lookup_code = wdj.status_type;
1068: ELSIF(l_wo_status=1) THEN
1069: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1070: l_WipEntityId_tbl,l_workorder_status_tbl
1071: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1072: WHERE wsr.parent_object_id=p_work_object_id
1073: AND wsr.parent_object_type_id= p_work_object_type_id
1074: AND wsr.child_object_type_id=p_work_object_type_id
1075: AND wsr.child_object_id=wdj.wip_entity_id

Line 1083: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1079: AND lk.lookup_code = wdj.status_type;
1080: ELSIF(l_wo_status IN (3,6)) THEN
1081: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1082: l_WipEntityId_tbl,l_workorder_status_tbl
1083: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1084: WHERE wsr.parent_object_id=p_work_object_id
1085: AND wsr.parent_object_type_id= p_work_object_type_id
1086: AND wsr.child_object_type_id=p_work_object_type_id
1087: AND wsr.child_object_id=wdj.wip_entity_id

Line 1095: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1091: AND lk.lookup_code = wdj.status_type;
1092: ELSIF(l_wo_status=7) THEN
1093: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1094: l_WipEntityId_tbl,l_workorder_status_tbl
1095: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1096: WHERE wsr.parent_object_id=p_work_object_id
1097: AND wsr.parent_object_type_id= p_work_object_type_id
1098: AND wsr.child_object_type_id=p_work_object_type_id
1099: AND wsr.child_object_id=wdj.wip_entity_id

Line 1107: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk

1103: AND lk.lookup_code = wdj.status_type;
1104: ELSIF(l_wo_status IN (4,5,12,14,15)) THEN
1105: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1106: l_WipEntityId_tbl,l_workorder_status_tbl
1107: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1108: WHERE wsr.parent_object_id=p_work_object_id
1109: AND wsr.parent_object_type_id= p_work_object_type_id
1110: AND wsr.child_object_type_id=p_work_object_type_id
1111: AND wsr.child_object_id=wdj.wip_entity_id