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.

[Home] [Help]

APPS.EAM_WO_SCHEDULE_PVT dependencies on WIP_OPERATION_NETWORKS

Line 953: FROM WIP_OPERATION_NETWORKS

949: SELECT -1 "LEVEL", operation_seq_num "OP_SEQ_NUM"
950: FROM wip_operations
951: WHERE wip_entity_id = p_wip_entity_id
952: AND operation_seq_num not in( SELECT prior_operation
953: FROM WIP_OPERATION_NETWORKS
954: WHERE wip_entity_id = p_wip_entity_id
955: UNION
956: SELECT next_operation
957: FROM WIP_OPERATION_NETWORKS

Line 957: FROM WIP_OPERATION_NETWORKS

953: FROM WIP_OPERATION_NETWORKS
954: WHERE wip_entity_id = p_wip_entity_id
955: UNION
956: SELECT next_operation
957: FROM WIP_OPERATION_NETWORKS
958: WHERE wip_entity_id = p_wip_entity_id)
959: UNION
960:
961: SELECT 0 "LEVEL", prior_operation "OP_SEQ_NUM"

Line 962: FROM wip_operation_networks

958: WHERE wip_entity_id = p_wip_entity_id)
959: UNION
960:
961: SELECT 0 "LEVEL", prior_operation "OP_SEQ_NUM"
962: FROM wip_operation_networks
963: WHERE prior_operation NOT IN
964: (SELECT next_operation
965: FROM wip_operation_networks
966: WHERE wip_entity_id = p_wip_entity_id )

Line 965: FROM wip_operation_networks

961: SELECT 0 "LEVEL", prior_operation "OP_SEQ_NUM"
962: FROM wip_operation_networks
963: WHERE prior_operation NOT IN
964: (SELECT next_operation
965: FROM wip_operation_networks
966: WHERE wip_entity_id = p_wip_entity_id )
967: AND wip_entity_id=p_wip_entity_id
968: UNION
969: SELECT max(level) "LEVEL", next_operation "OP_SEQ_NUM"

Line 970: FROM wip_operation_networks

966: WHERE wip_entity_id = p_wip_entity_id )
967: AND wip_entity_id=p_wip_entity_id
968: UNION
969: SELECT max(level) "LEVEL", next_operation "OP_SEQ_NUM"
970: FROM wip_operation_networks
971: WHERE wip_entity_id=p_wip_entity_id
972: START WITH prior_operation IN
973: (SELECT prior_operation
974: FROM wip_operation_networks

Line 974: FROM wip_operation_networks

970: FROM wip_operation_networks
971: WHERE wip_entity_id=p_wip_entity_id
972: START WITH prior_operation IN
973: (SELECT prior_operation
974: FROM wip_operation_networks
975: WHERE prior_operation NOT IN
976: (SELECT next_operation
977: FROM wip_operation_networks
978: WHERE wip_entity_id=p_wip_entity_id )

Line 977: FROM wip_operation_networks

973: (SELECT prior_operation
974: FROM wip_operation_networks
975: WHERE prior_operation NOT IN
976: (SELECT next_operation
977: FROM wip_operation_networks
978: WHERE wip_entity_id=p_wip_entity_id )
979: AND wip_entity_id=p_wip_entity_id)
980: CONNECT BY PRIOR next_operation = prior_operation
981: AND wip_entity_id = p_wip_entity_id

Line 991: FROM WIP_OPERATION_NETWORKS

987: SELECT -1 "LEVEL", operation_seq_num "OP_SEQ_NUM"
988: FROM wip_operations
989: WHERE wip_entity_id = p_wip_entity_id
990: AND operation_seq_num not in( SELECT prior_operation
991: FROM WIP_OPERATION_NETWORKS
992: WHERE wip_entity_id = p_wip_entity_id
993: UNION
994: SELECT next_operation
995: FROM WIP_OPERATION_NETWORKS

Line 995: FROM WIP_OPERATION_NETWORKS

991: FROM WIP_OPERATION_NETWORKS
992: WHERE wip_entity_id = p_wip_entity_id
993: UNION
994: SELECT next_operation
995: FROM WIP_OPERATION_NETWORKS
996: WHERE wip_entity_id = p_wip_entity_id)
997: UNION
998: SELECT 0 "LEVEL", next_operation "OP_SEQ_NUM"
999: FROM wip_operation_networks

Line 999: FROM wip_operation_networks

995: FROM WIP_OPERATION_NETWORKS
996: WHERE wip_entity_id = p_wip_entity_id)
997: UNION
998: SELECT 0 "LEVEL", next_operation "OP_SEQ_NUM"
999: FROM wip_operation_networks
1000: WHERE next_operation NOT IN
1001: (SELECT prior_operation
1002: FROM wip_operation_networks
1003: WHERE wip_entity_id = p_wip_entity_id )

Line 1002: FROM wip_operation_networks

998: SELECT 0 "LEVEL", next_operation "OP_SEQ_NUM"
999: FROM wip_operation_networks
1000: WHERE next_operation NOT IN
1001: (SELECT prior_operation
1002: FROM wip_operation_networks
1003: WHERE wip_entity_id = p_wip_entity_id )
1004: AND wip_entity_id=p_wip_entity_id
1005: UNION
1006: SELECT max(level) "LEVEL", prior_operation "OP_SEQ_NUM"

Line 1007: FROM wip_operation_networks

1003: WHERE wip_entity_id = p_wip_entity_id )
1004: AND wip_entity_id=p_wip_entity_id
1005: UNION
1006: SELECT max(level) "LEVEL", prior_operation "OP_SEQ_NUM"
1007: FROM wip_operation_networks
1008: WHERE wip_entity_id=p_wip_entity_id
1009: START WITH next_operation IN
1010: (SELECT next_operation
1011: FROM wip_operation_networks

Line 1011: FROM wip_operation_networks

1007: FROM wip_operation_networks
1008: WHERE wip_entity_id=p_wip_entity_id
1009: START WITH next_operation IN
1010: (SELECT next_operation
1011: FROM wip_operation_networks
1012: WHERE next_operation NOT IN
1013: (SELECT prior_operation
1014: FROM wip_operation_networks
1015: WHERE wip_entity_id=p_wip_entity_id )

Line 1014: FROM wip_operation_networks

1010: (SELECT next_operation
1011: FROM wip_operation_networks
1012: WHERE next_operation NOT IN
1013: (SELECT prior_operation
1014: FROM wip_operation_networks
1015: WHERE wip_entity_id=p_wip_entity_id )
1016: AND wip_entity_id=p_wip_entity_id)
1017: CONNECT BY PRIOR prior_operation = next_operation
1018: AND wip_entity_id = p_wip_entity_id

Line 1186: FROM wip_operation_networks

1182: dep_op_seq_num_tbl.delete;
1183:
1184: SELECT prior_operation
1185: BULK COLLECT INTO dep_op_seq_num_tbl
1186: FROM wip_operation_networks
1187: WHERE wip_entity_id = p_wip_entity_id
1188: AND next_operation = l_op_seq_num;
1189:
1190:

Line 1332: FROM wip_operation_networks

1328: dep_op_seq_num_tbl.delete;
1329:
1330: SELECT next_operation
1331: BULK COLLECT INTO dep_op_seq_num_tbl
1332: FROM wip_operation_networks
1333: WHERE wip_entity_id = p_wip_entity_id
1334: AND prior_operation = l_op_seq_num;
1335:
1336: DECLARE