APPS.CSTACWRO dependencies on WIP_OPERATION_OVERHEADS

Line 49: INSERT INTO WIP_OPERATION_OVERHEADS

45: **************************************************/
46:
47: stmt_num := 10;
48:
49: INSERT INTO WIP_OPERATION_OVERHEADS
50: (WIP_ENTITY_ID,
51: OPERATION_SEQ_NUM,
52: RESOURCE_SEQ_NUM,
53: ORGANIZATION_ID,

Line 116: WIP_OPERATION_OVERHEADS W2

112: WTA.COST_ELEMENT_ID = 5 AND
113: NOT EXISTS
114: (SELECT 'X'
115: FROM
116: WIP_OPERATION_OVERHEADS W2
117: WHERE
118: W2.WIP_ENTITY_ID = WCTI.WIP_ENTITY_ID AND
119: W2.ORGANIZATION_ID = WCTI.ORGANIZATION_ID AND
120: W2.OPERATION_SEQ_NUM = WCTI.OPERATION_SEQ_NUM AND

Line 142: UPDATE WIP_OPERATION_OVERHEADS W1

138: ***************************************************/
139:
140: stmt_num := 30;
141:
142: UPDATE WIP_OPERATION_OVERHEADS W1
143: SET
144: (APPLIED_OVHD_UNITS,
145: APPLIED_OVHD_VALUE) =
146: (SELECT

Line 216: INSERT INTO WIP_OPERATION_OVERHEADS

212: * Insert any rows for new department based ovhds ... *
213: *------------------------------------------------------------*/
214:
215:
216: INSERT INTO WIP_OPERATION_OVERHEADS
217: (WIP_ENTITY_ID,
218: OPERATION_SEQ_NUM,
219: RESOURCE_SEQ_NUM,
220: ORGANIZATION_ID,

Line 281: WIP_OPERATION_OVERHEADS W2

277: WTA.BASIS_TYPE IN (1,2) AND
278: WTA.REPETITIVE_SCHEDULE_ID IS NULL AND
279: NOT EXISTS
280: (SELECT 'X' FROM
281: WIP_OPERATION_OVERHEADS W2
282: WHERE
283: W2.WIP_ENTITY_ID = WCTI.WIP_ENTITY_ID AND
284: W2.ORGANIZATION_ID = WCTI.ORGANIZATION_ID AND
285: W2.OPERATION_SEQ_NUM = WCTI.OPERATION_SEQ_NUM AND

Line 300: WIP_OPERATION_OVERHEADS W1

296:
297: stmt_num := 60;
298:
299: UPDATE
300: WIP_OPERATION_OVERHEADS W1
301: SET
302: (APPLIED_OVHD_UNITS,
303: APPLIED_OVHD_VALUE) =
304: (SELECT