APPS.WIP_UNRELEASE dependencies on WIP_OPERATIONS

Line 79: FROM WIP_OPERATIONS

75: Sum(QUANTITY_RUNNING) +
76: Sum(QUANTITY_WAITING_TO_MOVE) +
77: Sum(QUANTITY_REJECTED) +
78: Sum(QUANTITY_SCRAPPED)), NULL, 'Y', 0, NULL, 'X') Result
79: FROM WIP_OPERATIONS
80: WHERE ORGANIZATION_ID = x_org_id
81: AND WIP_ENTITY_ID = x_wip_id) WHERE Result = 'X' ));
82:
83: cursor check_repetitive_charges is

Line 140: FROM WIP_OPERATIONS

136: AND TRANSACTION_SOURCE_TYPE_ID = 5
137: AND REPETITIVE_LINE_ID = x_line_id)
138: OR EXISTS
139: (SELECT 'X'
140: FROM WIP_OPERATIONS
141: WHERE WIP_ENTITY_ID = x_wip_id
142: AND ORGANIZATION_ID = x_org_id
143: AND REPETITIVE_SCHEDULE_ID = x_rep_id
144: AND QUANTITY_SCRAPPED <> 0)

Line 170: UPDATE WIP_OPERATIONS

166: fetch check_discrete_charges into charges_exist;
167:
168: IF (check_discrete_charges%NOTFOUND) THEN
169:
170: UPDATE WIP_OPERATIONS
171: SET QUANTITY_WAITING_TO_MOVE = 0,
172: QUANTITY_SCRAPPED = 0,
173: QUANTITY_REJECTED = 0,
174: QUANTITY_IN_QUEUE = 0,

Line 196: UPDATE WIP_OPERATIONS

192: open check_repetitive_charges;
193: fetch check_repetitive_charges into charges_exist;
194:
195: IF (check_repetitive_charges%NOTFOUND) THEN
196: UPDATE WIP_OPERATIONS
197: SET QUANTITY_WAITING_TO_MOVE = 0,
198: QUANTITY_SCRAPPED = 0,
199: QUANTITY_REJECTED = 0,
200: QUANTITY_IN_QUEUE = 0,