APPS.OPI_EDW_JOB_RSRC_PVT dependencies on WIP_MOVE_TXN_ALLOCATIONS

Line 37: FROM WIP_MOVE_TRANSACTIONS wmt, WIP_MOVE_TXN_ALLOCATIONS wmta

33: IF l_operation_seq_num = p_operation_seq_num THEN
34: /* First Operation */
35: SELECT min(wmt.transaction_date)
36: INTO l_strt_date
37: FROM WIP_MOVE_TRANSACTIONS wmt, WIP_MOVE_TXN_ALLOCATIONS wmta
38: WHERE wmt.organization_id = p_organization_id
39: AND wmt.wip_entity_id = p_wip_entity_id
40: AND wmt.transaction_id = wmta.transaction_id
41: AND wmta.repetitive_schedule_id = p_repetitive_schedule_id

Line 46: FROM WIP_MOVE_TRANSACTIONS wmt, WIP_MOVE_TXN_ALLOCATIONS wmta

42: AND wmt.fm_operation_seq_num = p_operation_seq_num ;
43: ELSE
44: SELECT min(wmt.transaction_date)
45: INTO l_strt_date
46: FROM WIP_MOVE_TRANSACTIONS wmt, WIP_MOVE_TXN_ALLOCATIONS wmta
47: WHERE wmt.organization_id = p_organization_id
48: AND wmt.wip_entity_id = p_wip_entity_id
49: AND wmt.transaction_id = wmta.transaction_id
50: AND wmta.repetitive_schedule_id = p_repetitive_schedule_id

Line 109: FROM WIP_MOVE_TRANSACTIONS wmt, WIP_MOVE_TXN_ALLOCATIONS wmta

105: IF l_operation_seq_num = p_operation_seq_num THEN
106: /* Last Operation */
107: SELECT max(wmt.transaction_date)
108: INTO l_cmpl_date
109: FROM WIP_MOVE_TRANSACTIONS wmt, WIP_MOVE_TXN_ALLOCATIONS wmta
110: WHERE wmt.organization_id = p_organization_id
111: AND wmt.wip_entity_id = p_wip_entity_id
112: AND wmt.transaction_id = wmta.transaction_id
113: AND wmta.repetitive_schedule_id = p_repetitive_schedule_id

Line 118: FROM WIP_MOVE_TRANSACTIONS wmt, WIP_MOVE_TXN_ALLOCATIONS wmta

114: AND wmt.to_operation_seq_num = p_operation_seq_num ;
115: ELSE
116: SELECT max(wmt.transaction_date)
117: INTO l_cmpl_date
118: FROM WIP_MOVE_TRANSACTIONS wmt, WIP_MOVE_TXN_ALLOCATIONS wmta
119: WHERE wmt.organization_id = p_organization_id
120: AND wmt.wip_entity_id = p_wip_entity_id
121: AND wmt.transaction_id = wmta.transaction_id
122: AND wmta.repetitive_schedule_id = p_repetitive_schedule_id