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 480: WIP_REQ_OPERATION_COST_DETAILS w2,

476: 3,cic.resource_cost,
477: 4,cic.outside_processing_cost,
478: 5,cic.overhead_cost),0)))
479: FROM
480: WIP_REQ_OPERATION_COST_DETAILS w2,
481: WIP_REQUIREMENT_OPERATIONS wro,
482: CST_QUANTITY_LAYERS cic
483: where
484: w2.WIP_ENTITY_ID = w1.WIP_ENTITY_ID AND

Line 574: WIP_REQ_OPERATION_COST_DETAILS wrocd

570: -1,
571: -1,
572: SYSDATE
573: FROM
574: WIP_REQ_OPERATION_COST_DETAILS wrocd
575: where
576: wrocd.WIP_ENTITY_ID = i_wip_entity_id AND
577: wrocd.ORGANIZATION_ID = i_org_id
578: GROUP BY wrocd.COST_ELEMENT_ID

Line 2079: UPDATE WIP_REQ_OPERATION_COST_DETAILS

2075: ***************************************************/
2076:
2077: stmt_num := 10;
2078:
2079: UPDATE WIP_REQ_OPERATION_COST_DETAILS
2080: SET temp_relieved_value = 0
2081: where
2082: WIP_ENTITY_ID = i_wip_entity_id;
2083:

Line 2135: UPDATE WIP_REQ_OPERATION_COST_DETAILS W1

2131: * Compute PL Costs for WIP Scrap Return ... *
2132: ******************************************************/
2133: stmt_num := 100;
2134:
2135: UPDATE WIP_REQ_OPERATION_COST_DETAILS W1
2136: SET
2137: (TEMP_RELIEVED_VALUE,
2138: RELIEVED_MATL_SCRAP_VALUE) =
2139: (SELECT

Line 2190: WIP_REQ_OPERATION_COST_DETAILS W2,

2186: -1*nvl(relieved_matl_scrap_value,0),
2187: -1*SIGN(wro.quantity_per_assembly),
2188: -1*nvl(relieved_matl_scrap_value,0))
2189: FROM
2190: WIP_REQ_OPERATION_COST_DETAILS W2,
2191: WIP_REQUIREMENT_OPERATIONS WRO
2192: WHERE
2193: W1.WIP_ENTITY_ID = W2.WIP_ENTITY_ID AND
2194: W1.ORGANIZATION_ID = W2.ORGANIZATION_ID AND

Line 2284: WIP_REQ_OPERATION_COST_DETAILS wrocd

2280: -1,
2281: -1,
2282: SYSDATE
2283: FROM
2284: WIP_REQ_OPERATION_COST_DETAILS wrocd
2285: where
2286: wrocd.WIP_ENTITY_ID = i_wip_entity_id AND
2287: wrocd.ORGANIZATION_ID = i_org_id
2288: GROUP BY wrocd.COST_ELEMENT_ID