APPS.OPI_EDW_JOB_RSRC_PVT dependencies on WIP_MOVE_TRANSACTIONS

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 60: FROM WIP_MOVE_TRANSACTIONS

56: IF l_operation_seq_num = p_operation_seq_num THEN
57: /* First Operation */
58: SELECT min(transaction_date)
59: INTO l_strt_date
60: FROM WIP_MOVE_TRANSACTIONS
61: WHERE organization_id = p_organization_id
62: AND wip_entity_id = p_wip_entity_id
63: AND fm_operation_seq_num = p_operation_seq_num ;
64: ELSE

Line 68: FROM WIP_MOVE_TRANSACTIONS

64: ELSE
65:
66: SELECT min(transaction_date)
67: INTO l_strt_date
68: FROM WIP_MOVE_TRANSACTIONS
69: WHERE organization_id = p_organization_id
70: AND wip_entity_id = p_wip_entity_id
71: AND to_operation_seq_num = p_operation_seq_num ;
72:

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

Line 141: FROM WIP_MOVE_TRANSACTIONS wmt

137: IF l_operation_seq_num = p_operation_seq_num THEN
138: /* Last Operation */
139: SELECT max(wmt.transaction_date)
140: INTO l_cmpl_date
141: FROM WIP_MOVE_TRANSACTIONS wmt
142: WHERE wmt.organization_id = p_organization_id
143: AND wmt.wip_entity_id = p_wip_entity_id
144: AND wmt.to_operation_seq_num = p_operation_seq_num ;
145: ELSE

Line 148: FROM WIP_MOVE_TRANSACTIONS wmt

144: AND wmt.to_operation_seq_num = p_operation_seq_num ;
145: ELSE
146: SELECT max(wmt.transaction_date)
147: INTO l_cmpl_date
148: FROM WIP_MOVE_TRANSACTIONS wmt
149: WHERE wmt.organization_id = p_organization_id
150: AND wmt.wip_entity_id = p_wip_entity_id
151: AND wmt.fm_operation_seq_num = p_operation_seq_num ;
152: END IF ;