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.BOM_VALIDATE_SUB_OP_RES dependencies on WIP_SUB_OPERATION_RESOURCES

Line 74: FROM WIP_SUB_OPERATION_RESOURCES wsor

70: WHERE wdj.lot_number = p_lot_number
71: AND (wdj.status_type <> 1
72: OR
73: NOT EXISTS(SELECT NULL
74: FROM WIP_SUB_OPERATION_RESOURCES wsor
75: WHERE substitute_group_num = p_sub_group_num
76: AND resource_id = p_resource_id
77: AND operation_seq_num = p_operation_seq_num
78: AND wip_entity_id = wdj.wip_entity_id)

Line 96: FROM WIP_SUB_OPERATION_RESOURCES wsor

92: FROM WIP_DISCRETE_JOBS wdj
93: WHERE wdj.lot_number = p_lot_number
94: AND wdj.status_type = 1
95: AND EXISTS ( SELECT NULL
96: FROM WIP_SUB_OPERATION_RESOURCES wsor
97: WHERE substitute_group_num = p_sub_group_num
98: AND resource_id = p_resource_id
99: AND operation_seq_num = p_operation_seq_num
100: AND wip_entity_id = wdj.wip_entity_id

Line 120: FROM WIP_SUB_OPERATION_RESOURCES wsor

116: , WIP_ENTITIES we2
117: WHERE (wdj.status_type <> 1
118: OR
119: NOT EXISTS (SELECT NULL
120: FROM WIP_SUB_OPERATION_RESOURCES wsor
121: WHERE substitute_group_num = p_sub_group_num
122: AND resource_id = p_resource_id
123: AND operation_seq_num = p_operation_seq_num
124: AND wip_entity_id = wdj.wip_entity_id)

Line 147: FROM WIP_SUB_OPERATION_RESOURCES wsor

143: FROM WIP_DISCRETE_JOBS wdj
144: WHERE (wdj.status_type <> 1
145: OR
146: NOT EXISTS(SELECT NULL
147: FROM WIP_SUB_OPERATION_RESOURCES wsor
148: WHERE substitute_group_num = p_sub_group_num
149: AND resource_id = p_resource_id
150: AND operation_seq_num = p_operation_seq_num
151: AND wip_entity_id = wdj.wip_entity_id)