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 196: WIP_DISCRETE_JOBS WDJ1,

192: WHERE WSR.SCHED_RELATIONSHIP_ID IN
193: (
194: SELECT WSR1.SCHED_RELATIONSHIP_ID
195: FROM WIP_SCHED_RELATIONSHIPS WSR1,
196: WIP_DISCRETE_JOBS WDJ1,
197: WIP_DISCRETE_JOBS WDJ2
198: WHERE WSR1.PARENT_OBJECT_TYPE_ID = 1
199: AND WSR1.CHILD_OBJECT_TYPE_ID = 1
200: AND WDJ1.WIP_ENTITY_ID = WSR1.PARENT_OBJECT_ID

Line 197: WIP_DISCRETE_JOBS WDJ2

193: (
194: SELECT WSR1.SCHED_RELATIONSHIP_ID
195: FROM WIP_SCHED_RELATIONSHIPS WSR1,
196: WIP_DISCRETE_JOBS WDJ1,
197: WIP_DISCRETE_JOBS WDJ2
198: WHERE WSR1.PARENT_OBJECT_TYPE_ID = 1
199: AND WSR1.CHILD_OBJECT_TYPE_ID = 1
200: AND WDJ1.WIP_ENTITY_ID = WSR1.PARENT_OBJECT_ID
201: AND WDJ2.WIP_ENTITY_ID = WSR1.CHILD_OBJECT_ID

Line 214: WIP_DISCRETE_JOBS WDJ1,

210: WHERE EWR.WO_RELATIONSHIP_ID IN
211: (
212: SELECT EWR1.WO_RELATIONSHIP_ID
213: FROM EAM_WO_RELATIONSHIPS EWR1,
214: WIP_DISCRETE_JOBS WDJ1,
215: WIP_DISCRETE_JOBS WDJ2
216: WHERE EWR1.PARENT_OBJECT_TYPE_ID = 1
217: AND EWR1.CHILD_OBJECT_TYPE_ID = 1
218: AND WDJ1.WIP_ENTITY_ID = EWR1.PARENT_OBJECT_ID

Line 215: WIP_DISCRETE_JOBS WDJ2

211: (
212: SELECT EWR1.WO_RELATIONSHIP_ID
213: FROM EAM_WO_RELATIONSHIPS EWR1,
214: WIP_DISCRETE_JOBS WDJ1,
215: WIP_DISCRETE_JOBS WDJ2
216: WHERE EWR1.PARENT_OBJECT_TYPE_ID = 1
217: AND EWR1.CHILD_OBJECT_TYPE_ID = 1
218: AND WDJ1.WIP_ENTITY_ID = EWR1.PARENT_OBJECT_ID
219: AND WDJ2.WIP_ENTITY_ID = EWR1.CHILD_OBJECT_ID

Line 242: WIP_DISCRETE_JOBS WDJ

238:
239: SELECT COUNT(WSR.SCHED_RELATIONSHIP_ID)
240: INTO l_released_rowcount
241: FROM WIP_SCHED_RELATIONSHIPS WSR,
242: WIP_DISCRETE_JOBS WDJ
243: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
244: AND WSR.CHILD_OBJECT_TYPE_ID = 1
245: AND WDJ.WIP_ENTITY_ID = WSR.CHILD_OBJECT_ID
246: AND WDJ.STATUS_TYPE IN (3,4,5,6,7,12,14,15)

Line 755: FROM WIP_DISCRETE_JOBS WDJ1,

751: AND WSR.PARENT_OBJECT_TYPE_ID = l_parent_object_type_id
752: AND WSR.PARENT_OBJECT_ID = l_parent_object_id
753: AND WSR.RELATIONSHIP_TYPE = 1
754: AND EXISTS (SELECT *
755: FROM WIP_DISCRETE_JOBS WDJ1,
756: WIP_DISCRETE_JOBS WDJ2
757: WHERE WDJ1.WIP_ENTITY_ID = l_parent_object_id
758: AND WDJ2.WIP_ENTITY_ID = child.child_object_id
759: AND (WDJ2.SCHEDULED_START_DATE < WDJ1.SCHEDULED_START_DATE

Line 756: WIP_DISCRETE_JOBS WDJ2

752: AND WSR.PARENT_OBJECT_ID = l_parent_object_id
753: AND WSR.RELATIONSHIP_TYPE = 1
754: AND EXISTS (SELECT *
755: FROM WIP_DISCRETE_JOBS WDJ1,
756: WIP_DISCRETE_JOBS WDJ2
757: WHERE WDJ1.WIP_ENTITY_ID = l_parent_object_id
758: AND WDJ2.WIP_ENTITY_ID = child.child_object_id
759: AND (WDJ2.SCHEDULED_START_DATE < WDJ1.SCHEDULED_START_DATE
760: OR

Line 775: FROM WIP_DISCRETE_JOBS WDJ1,

771: AND EWR.PARENT_OBJECT_TYPE_ID = l_parent_object_type_id
772: AND EWR.PARENT_OBJECT_ID = l_parent_object_id
773: AND EWR.PARENT_RELATIONSHIP_TYPE = 1
774: AND EXISTS (SELECT *
775: FROM WIP_DISCRETE_JOBS WDJ1,
776: WIP_DISCRETE_JOBS WDJ2
777: WHERE WDJ1.WIP_ENTITY_ID = l_parent_object_id
778: AND WDJ2.WIP_ENTITY_ID = child.child_object_id
779: AND (WDJ2.SCHEDULED_START_DATE < WDJ1.SCHEDULED_START_DATE

Line 776: WIP_DISCRETE_JOBS WDJ2

772: AND EWR.PARENT_OBJECT_ID = l_parent_object_id
773: AND EWR.PARENT_RELATIONSHIP_TYPE = 1
774: AND EXISTS (SELECT *
775: FROM WIP_DISCRETE_JOBS WDJ1,
776: WIP_DISCRETE_JOBS WDJ2
777: WHERE WDJ1.WIP_ENTITY_ID = l_parent_object_id
778: AND WDJ2.WIP_ENTITY_ID = child.child_object_id
779: AND (WDJ2.SCHEDULED_START_DATE < WDJ1.SCHEDULED_START_DATE
780: OR

Line 804: WIP_DISCRETE_JOBS WDJ

800:
801: SELECT COUNT(SCHED_RELATIONSHIP_ID)
802: INTO l_released_rowcount
803: FROM WIP_SCHED_RELATIONSHIPS WSR,
804: WIP_DISCRETE_JOBS WDJ
805: WHERE WSR.PARENT_OBJECT_TYPE_ID = 1
806: AND WSR.CHILD_OBJECT_TYPE_ID = 1
807: AND WSR.PARENT_OBJECT_ID = l_parent_object_id
808: AND WSR.PARENT_OBJECT_TYPE_ID = l_parent_object_type_id

Line 932: FROM wip_discrete_jobs wdj,eam_work_order_details_v ewod

928: --Bug #5350181 :Changed the query to capture pending flag and user defined status
929: BEGIN
930: SELECT wdj.status_type,ewod.user_defined_status_id,ewod.pending_flag
931: INTO l_wo_status,l_user_defined_status,l_pending_flag
932: FROM wip_discrete_jobs wdj,eam_work_order_details_v ewod
933: WHERE wdj.wip_entity_id=p_work_object_id
934: and ewod.wip_entity_id=wdj.wip_entity_id;
935: EXCEPTION -- added exception for bug 13736177
936: WHEN NO_DATA_FOUND THEN

Line 938: from wip_discrete_jobs where wip_entity_id = p_work_object_id;

934: and ewod.wip_entity_id=wdj.wip_entity_id;
935: EXCEPTION -- added exception for bug 13736177
936: WHEN NO_DATA_FOUND THEN
937: select status_type into l_wo_status
938: from wip_discrete_jobs where wip_entity_id = p_work_object_id;
939: l_user_defined_status := l_wo_status;
940: l_pending_flag := null;
941: END;
942:

Line 948: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

944:
945: BEGIN
946: SELECT wdj.status_type
947: INTO l_parent_status
948: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
949: WHERE wsr.child_object_id =p_work_object_id
950: and wsr.child_object_type_id = p_work_object_type_id
951: and wsr.relationship_type = 1
952: and wdj.wip_entity_id = wsr.parent_object_id;

Line 980: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

976:
977: IF(l_wo_status=17) THEN
978: SELECT COUNT(*)
979: INTO l_invalid_child
980: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
981: WHERE wsr.parent_object_id=p_work_object_id
982: AND wsr.parent_object_type_id= p_work_object_type_id
983: AND wsr.child_object_type_id=p_work_object_type_id
984: AND wsr.child_object_id=wdj.wip_entity_id

Line 990: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

986: AND wdj.status_type NOT IN (17,7,6);
987: ELSIF(l_wo_status=1) THEN
988: SELECT COUNT(*)
989: INTO l_invalid_child
990: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
991: WHERE wsr.parent_object_id=p_work_object_id
992: AND wsr.parent_object_type_id= p_work_object_type_id
993: AND wsr.child_object_type_id=p_work_object_type_id
994: AND wsr.child_object_id=wdj.wip_entity_id

Line 1000: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

996: AND wdj.status_type NOT IN (17,7,1,6);
997: ELSIF(l_wo_status IN (3,6)) THEN
998: SELECT COUNT(*)
999: INTO l_invalid_child
1000: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
1001: WHERE wsr.parent_object_id=p_work_object_id
1002: AND wsr.parent_object_type_id= p_work_object_type_id
1003: AND wsr.child_object_type_id=p_work_object_type_id
1004: AND wsr.child_object_id=wdj.wip_entity_id

Line 1010: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

1006: AND wdj.status_type NOT IN (3,6,17,7,1,12,14,15,4,5);
1007: ELSIF(l_wo_status=7) THEN
1008: SELECT COUNT(*)
1009: INTO l_invalid_child
1010: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
1011: WHERE wsr.parent_object_id=p_work_object_id
1012: AND wsr.parent_object_type_id= p_work_object_type_id
1013: AND wsr.child_object_type_id=p_work_object_type_id
1014: AND wsr.child_object_id=wdj.wip_entity_id

Line 1020: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr

1016: AND wdj.status_type NOT IN (7,12,14,15);
1017: ELSIF(l_wo_status IN (4,5,12,14,15)) THEN
1018: SELECT COUNT(*)
1019: INTO l_invalid_child
1020: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr
1021: WHERE wsr.parent_object_id=p_work_object_id
1022: AND wsr.parent_object_type_id= p_work_object_type_id
1023: AND wsr.child_object_type_id=p_work_object_type_id
1024: AND wsr.child_object_id=wdj.wip_entity_id

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

1078:
1079: IF(l_wo_status=17) THEN
1080: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1081: l_WipEntityId_tbl,l_workorder_status_tbl
1082: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1083: WHERE wsr.parent_object_id=p_work_object_id
1084: AND wsr.parent_object_type_id= p_work_object_type_id
1085: AND wsr.child_object_type_id=p_work_object_type_id
1086: AND wsr.child_object_id=wdj.wip_entity_id

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

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

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

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

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

1114: AND lk.lookup_code = wdj.status_type;
1115: ELSIF(l_wo_status=7) THEN
1116: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1117: l_WipEntityId_tbl,l_workorder_status_tbl
1118: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1119: WHERE wsr.parent_object_id=p_work_object_id
1120: AND wsr.parent_object_type_id= p_work_object_type_id
1121: AND wsr.child_object_type_id=p_work_object_type_id
1122: AND wsr.child_object_id=wdj.wip_entity_id

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

1126: AND lk.lookup_code = wdj.status_type;
1127: ELSIF(l_wo_status IN (4,5,12,14,15)) THEN
1128: SELECT wsr.child_object_id,lk.meaning BULK COLLECT INTO
1129: l_WipEntityId_tbl,l_workorder_status_tbl
1130: FROM wip_discrete_jobs wdj,wip_sched_relationships wsr,mfg_lookups lk
1131: WHERE wsr.parent_object_id=p_work_object_id
1132: AND wsr.parent_object_type_id= p_work_object_type_id
1133: AND wsr.child_object_type_id=p_work_object_type_id
1134: AND wsr.child_object_id=wdj.wip_entity_id