APPS.CSTPACWS dependencies on WIP_REQUIREMENT_OPERATIONS

Line 37: wip_requirement_operations wro

33: inventory_item_id,
34: operation_seq_num,
35: wip_supply_type
36: FROM
37: wip_requirement_operations wro
38: WHERE
39: --
40: -- Exclude bulk, supplier, phantom
41: --

Line 148: WIP_REQUIREMENT_OPERATIONS WRO,

144: -1,
145: -1,
146: SYSDATE
147: from
148: WIP_REQUIREMENT_OPERATIONS WRO,
149: CST_LAYER_COST_DETAILS CLCD,
150: CST_QUANTITY_LAYERS CQL
151: WHERE
152: WRO.WIP_ENTITY_ID = i_wip_entity_id AND

Line 539: WIP_REQUIREMENT_OPERATIONS wro,

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
543: w2.ORGANIZATION_ID = w1.ORGANIZATION_ID AND

Line 570: UPDATE WIP_REQUIREMENT_OPERATIONS w

566: -- ******************************************************/
567:
568: stmt_num := 110;
569:
570: UPDATE WIP_REQUIREMENT_OPERATIONS w
571: SET RELIEVED_MATL_SCRAP_QUANTITY =
572: (SELECT
573: nvl(w.RELIEVED_MATL_SCRAP_QUANTITY,0) +
574: /* LBM Project Changes */

Line 582: WIP_REQUIREMENT_OPERATIONS w2

578: decode(l_include_comp_yield,
579: 1, nvl(w2.component_yield_factor,1),
580: 1))
581: FROM
582: WIP_REQUIREMENT_OPERATIONS w2
583: where
584: w.WIP_ENTITY_ID = w2.WIP_ENTITY_ID AND
585: w.INVENTORY_ITEM_ID = w2.INVENTORY_ITEM_ID AND
586: w.OPERATION_SEQ_NUM = w2.OPERATION_SEQ_NUM AND

Line 2347: WIP_REQUIREMENT_OPERATIONS WRO

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
2351: W1.OPERATION_SEQ_NUM = W2.OPERATION_SEQ_NUM AND

Line 2365: WIP_REQUIREMENT_OPERATIONS wro2

2361: (SELECT
2362: WIP_ENTITY_ID, ORGANIZATION_ID,
2363: INVENTORY_ITEM_ID,OPERATION_SEQ_NUM
2364: from
2365: WIP_REQUIREMENT_OPERATIONS wro2
2366: where
2367: wro2.WIP_ENTITY_ID = i_wip_entity_id AND
2368: wro2.ORGANIZATION_ID = i_org_id AND
2369: wro2.QUANTITY_PER_ASSEMBLY <> 0 AND

Line 2378: UPDATE WIP_REQUIREMENT_OPERATIONS w

2374:
2375:
2376: stmt_num := 120;
2377:
2378: UPDATE WIP_REQUIREMENT_OPERATIONS w
2379: SET RELIEVED_MATL_SCRAP_QUANTITY =
2380: (SELECT
2381: nvl(w.RELIEVED_MATL_SCRAP_QUANTITY,0) +
2382: decode(w2.RELIEVED_MATL_SCRAP_QUANTITY,

Line 2392: WIP_REQUIREMENT_OPERATIONS w2

2388: decode(l_include_comp_yield,
2389: 1, nvl(w2.component_yield_factor,1),
2390: 1)))
2391: FROM
2392: WIP_REQUIREMENT_OPERATIONS w2
2393: where
2394: w.WIP_ENTITY_ID = w2.WIP_ENTITY_ID AND
2395: w.INVENTORY_ITEM_ID = w2.INVENTORY_ITEM_ID AND
2396: w.OPERATION_SEQ_NUM = w2.OPERATION_SEQ_NUM AND