APPS.CSTPACWS dependencies on WIP_REQ_OPERATION_COST_DETAILS

Line 56: UPDATE WIP_REQ_OPERATION_COST_DETAILS

52: ***************************************************/
53:
54: stmt_num := 10;
55:
56: UPDATE WIP_REQ_OPERATION_COST_DETAILS
57: SET temp_relieved_value = 0
58: where
59: WIP_ENTITY_ID = i_wip_entity_id;
60:

Line 115: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS

111: -- components. Therefore insert rows for all components.
112: -- If some components have been issued, they should not be inserted
113:
114:
115: INSERT INTO WIP_REQ_OPERATION_COST_DETAILS
116: (WIP_ENTITY_ID,
117: OPERATION_SEQ_NUM,
118: ORGANIZATION_ID,
119: INVENTORY_ITEM_ID,

Line 162: WIP_REQ_OPERATION_COST_DETAILS WROCD

158: not EXISTS
159: (SELECT
160: 'X'
161: FROM
162: WIP_REQ_OPERATION_COST_DETAILS WROCD
163: WHERE
164: WROCD.WIP_ENTITY_ID = i_wip_entity_id AND
165: WROCD.INVENTORY_ITEM_ID= WRO.INVENTORY_ITEM_ID AND
166: WROCD.OPERATION_SEQ_NUM= WRO.OPERATION_SEQ_NUM AND

Line 213: UPDATE WIP_REQ_OPERATION_COST_DETAILS w1

209: WHEN Others THEN
210: l_future_issued_qty := 0;
211: END;
212:
213: UPDATE WIP_REQ_OPERATION_COST_DETAILS w1
214: SET (temp_relieved_value,
215: relieved_matl_scrap_value) =
216: (SELECT
217: decode(SIGN(nvl(wro.quantity_issued,0)-

Line 538: WIP_REQ_OPERATION_COST_DETAILS w2,

534: 3,cic.resource_cost,
535: 4,cic.outside_processing_cost,
536: 5,cic.overhead_cost),0)))
537: FROM
538: WIP_REQ_OPERATION_COST_DETAILS w2,
539: WIP_REQUIREMENT_OPERATIONS wro,
540: CST_QUANTITY_LAYERS cic
541: where
542: w2.WIP_ENTITY_ID = w1.WIP_ENTITY_ID AND

Line 632: WIP_REQ_OPERATION_COST_DETAILS wrocd

628: -1,
629: -1,
630: SYSDATE
631: FROM
632: WIP_REQ_OPERATION_COST_DETAILS wrocd
633: where
634: wrocd.WIP_ENTITY_ID = i_wip_entity_id AND
635: wrocd.ORGANIZATION_ID = i_org_id
636: GROUP BY wrocd.COST_ELEMENT_ID

Line 2235: UPDATE WIP_REQ_OPERATION_COST_DETAILS

2231: ***************************************************/
2232:
2233: stmt_num := 10;
2234:
2235: UPDATE WIP_REQ_OPERATION_COST_DETAILS
2236: SET temp_relieved_value = 0
2237: where
2238: WIP_ENTITY_ID = i_wip_entity_id;
2239:

Line 2291: UPDATE WIP_REQ_OPERATION_COST_DETAILS W1

2287: * Compute PL Costs for WIP Scrap Return ... *
2288: ******************************************************/
2289: stmt_num := 100;
2290:
2291: UPDATE WIP_REQ_OPERATION_COST_DETAILS W1
2292: SET
2293: (TEMP_RELIEVED_VALUE,
2294: RELIEVED_MATL_SCRAP_VALUE) =
2295: (SELECT

Line 2346: WIP_REQ_OPERATION_COST_DETAILS W2,

2342: -1*nvl(relieved_matl_scrap_value,0),
2343: -1*SIGN(wro.quantity_per_assembly),
2344: -1*nvl(relieved_matl_scrap_value,0))
2345: FROM
2346: WIP_REQ_OPERATION_COST_DETAILS W2,
2347: WIP_REQUIREMENT_OPERATIONS WRO
2348: WHERE
2349: W1.WIP_ENTITY_ID = W2.WIP_ENTITY_ID AND
2350: W1.ORGANIZATION_ID = W2.ORGANIZATION_ID AND

Line 2440: WIP_REQ_OPERATION_COST_DETAILS wrocd

2436: -1,
2437: -1,
2438: SYSDATE
2439: FROM
2440: WIP_REQ_OPERATION_COST_DETAILS wrocd
2441: where
2442: wrocd.WIP_ENTITY_ID = i_wip_entity_id AND
2443: wrocd.ORGANIZATION_ID = i_org_id
2444: GROUP BY wrocd.COST_ELEMENT_ID