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_SCHEDULE_PVT dependencies on WIP_OPERATION_NETWORKS

Line 972: FROM WIP_OPERATION_NETWORKS

968: SELECT -1 "LEVEL", operation_seq_num "OP_SEQ_NUM"
969: FROM wip_operations
970: WHERE wip_entity_id = p_wip_entity_id
971: AND operation_seq_num not in( SELECT prior_operation
972: FROM WIP_OPERATION_NETWORKS
973: WHERE wip_entity_id = p_wip_entity_id
974: UNION
975: SELECT next_operation
976: FROM WIP_OPERATION_NETWORKS

Line 976: FROM WIP_OPERATION_NETWORKS

972: FROM WIP_OPERATION_NETWORKS
973: WHERE wip_entity_id = p_wip_entity_id
974: UNION
975: SELECT next_operation
976: FROM WIP_OPERATION_NETWORKS
977: WHERE wip_entity_id = p_wip_entity_id)
978: UNION
979:
980: SELECT 0 "LEVEL", prior_operation "OP_SEQ_NUM"

Line 981: FROM wip_operation_networks

977: WHERE wip_entity_id = p_wip_entity_id)
978: UNION
979:
980: SELECT 0 "LEVEL", prior_operation "OP_SEQ_NUM"
981: FROM wip_operation_networks
982: WHERE prior_operation NOT IN
983: (SELECT next_operation
984: FROM wip_operation_networks
985: WHERE wip_entity_id = p_wip_entity_id )

Line 984: FROM wip_operation_networks

980: SELECT 0 "LEVEL", prior_operation "OP_SEQ_NUM"
981: FROM wip_operation_networks
982: WHERE prior_operation NOT IN
983: (SELECT next_operation
984: FROM wip_operation_networks
985: WHERE wip_entity_id = p_wip_entity_id )
986: AND wip_entity_id=p_wip_entity_id
987: UNION
988: SELECT max(level) "LEVEL", next_operation "OP_SEQ_NUM"

Line 989: FROM (SELECT * FROM wip_operation_networks

985: WHERE wip_entity_id = p_wip_entity_id )
986: AND wip_entity_id=p_wip_entity_id
987: UNION
988: SELECT max(level) "LEVEL", next_operation "OP_SEQ_NUM"
989: FROM (SELECT * FROM wip_operation_networks
990: WHERE wip_entity_id=p_wip_entity_id)
991: START WITH prior_operation IN
992: (SELECT prior_operation
993: FROM wip_operation_networks

Line 993: FROM wip_operation_networks

989: FROM (SELECT * FROM wip_operation_networks
990: WHERE wip_entity_id=p_wip_entity_id)
991: START WITH prior_operation IN
992: (SELECT prior_operation
993: FROM wip_operation_networks
994: WHERE prior_operation NOT IN
995: (SELECT next_operation
996: FROM wip_operation_networks
997: WHERE wip_entity_id=p_wip_entity_id )

Line 996: FROM wip_operation_networks

992: (SELECT prior_operation
993: FROM wip_operation_networks
994: WHERE prior_operation NOT IN
995: (SELECT next_operation
996: FROM wip_operation_networks
997: WHERE wip_entity_id=p_wip_entity_id )
998: AND wip_entity_id=p_wip_entity_id)
999: CONNECT BY PRIOR next_operation = prior_operation
1000: AND wip_entity_id = p_wip_entity_id

Line 1010: FROM WIP_OPERATION_NETWORKS

1006: SELECT -1 "LEVEL", operation_seq_num "OP_SEQ_NUM"
1007: FROM wip_operations
1008: WHERE wip_entity_id = p_wip_entity_id
1009: AND operation_seq_num not in( SELECT prior_operation
1010: FROM WIP_OPERATION_NETWORKS
1011: WHERE wip_entity_id = p_wip_entity_id
1012: UNION
1013: SELECT next_operation
1014: FROM WIP_OPERATION_NETWORKS

Line 1014: FROM WIP_OPERATION_NETWORKS

1010: FROM WIP_OPERATION_NETWORKS
1011: WHERE wip_entity_id = p_wip_entity_id
1012: UNION
1013: SELECT next_operation
1014: FROM WIP_OPERATION_NETWORKS
1015: WHERE wip_entity_id = p_wip_entity_id)
1016: UNION
1017: SELECT 0 "LEVEL", next_operation "OP_SEQ_NUM"
1018: FROM wip_operation_networks

Line 1018: FROM wip_operation_networks

1014: FROM WIP_OPERATION_NETWORKS
1015: WHERE wip_entity_id = p_wip_entity_id)
1016: UNION
1017: SELECT 0 "LEVEL", next_operation "OP_SEQ_NUM"
1018: FROM wip_operation_networks
1019: WHERE next_operation NOT IN
1020: (SELECT prior_operation
1021: FROM wip_operation_networks
1022: WHERE wip_entity_id = p_wip_entity_id )

Line 1021: FROM wip_operation_networks

1017: SELECT 0 "LEVEL", next_operation "OP_SEQ_NUM"
1018: FROM wip_operation_networks
1019: WHERE next_operation NOT IN
1020: (SELECT prior_operation
1021: FROM wip_operation_networks
1022: WHERE wip_entity_id = p_wip_entity_id )
1023: AND wip_entity_id=p_wip_entity_id
1024: UNION
1025: SELECT max(level) "LEVEL", prior_operation "OP_SEQ_NUM"

Line 1026: FROM (SELECT * FROM wip_operation_networks

1022: WHERE wip_entity_id = p_wip_entity_id )
1023: AND wip_entity_id=p_wip_entity_id
1024: UNION
1025: SELECT max(level) "LEVEL", prior_operation "OP_SEQ_NUM"
1026: FROM (SELECT * FROM wip_operation_networks
1027: WHERE wip_entity_id=p_wip_entity_id)
1028: START WITH next_operation IN
1029: (SELECT next_operation
1030: FROM wip_operation_networks

Line 1030: FROM wip_operation_networks

1026: FROM (SELECT * FROM wip_operation_networks
1027: WHERE wip_entity_id=p_wip_entity_id)
1028: START WITH next_operation IN
1029: (SELECT next_operation
1030: FROM wip_operation_networks
1031: WHERE next_operation NOT IN
1032: (SELECT prior_operation
1033: FROM wip_operation_networks
1034: WHERE wip_entity_id=p_wip_entity_id )

Line 1033: FROM wip_operation_networks

1029: (SELECT next_operation
1030: FROM wip_operation_networks
1031: WHERE next_operation NOT IN
1032: (SELECT prior_operation
1033: FROM wip_operation_networks
1034: WHERE wip_entity_id=p_wip_entity_id )
1035: AND wip_entity_id=p_wip_entity_id)
1036: CONNECT BY PRIOR prior_operation = next_operation
1037: AND wip_entity_id = p_wip_entity_id

Line 1205: FROM wip_operation_networks

1201: dep_op_seq_num_tbl.delete;
1202:
1203: SELECT prior_operation
1204: BULK COLLECT INTO dep_op_seq_num_tbl
1205: FROM wip_operation_networks
1206: WHERE wip_entity_id = p_wip_entity_id
1207: AND next_operation = l_op_seq_num;
1208:
1209:

Line 1351: FROM wip_operation_networks

1347: dep_op_seq_num_tbl.delete;
1348:
1349: SELECT next_operation
1350: BULK COLLECT INTO dep_op_seq_num_tbl
1351: FROM wip_operation_networks
1352: WHERE wip_entity_id = p_wip_entity_id
1353: AND prior_operation = l_op_seq_num;
1354:
1355: DECLARE