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 481: WIP_REQUIREMENT_OPERATIONS wro,

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

Line 512: UPDATE WIP_REQUIREMENT_OPERATIONS w

508: -- ******************************************************/
509:
510: stmt_num := 110;
511:
512: UPDATE WIP_REQUIREMENT_OPERATIONS w
513: SET RELIEVED_MATL_SCRAP_QUANTITY =
514: (SELECT
515: nvl(w.RELIEVED_MATL_SCRAP_QUANTITY,0) +
516: /* LBM Project Changes */

Line 524: WIP_REQUIREMENT_OPERATIONS w2

520: decode(l_include_comp_yield,
521: 1, nvl(w2.component_yield_factor,1),
522: 1))
523: FROM
524: WIP_REQUIREMENT_OPERATIONS w2
525: where
526: w.WIP_ENTITY_ID = w2.WIP_ENTITY_ID AND
527: w.INVENTORY_ITEM_ID = w2.INVENTORY_ITEM_ID AND
528: w.OPERATION_SEQ_NUM = w2.OPERATION_SEQ_NUM AND

Line 2191: WIP_REQUIREMENT_OPERATIONS WRO

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

Line 2209: WIP_REQUIREMENT_OPERATIONS wro2

2205: (SELECT
2206: WIP_ENTITY_ID, ORGANIZATION_ID,
2207: INVENTORY_ITEM_ID,OPERATION_SEQ_NUM
2208: from
2209: WIP_REQUIREMENT_OPERATIONS wro2
2210: where
2211: wro2.WIP_ENTITY_ID = i_wip_entity_id AND
2212: wro2.ORGANIZATION_ID = i_org_id AND
2213: wro2.QUANTITY_PER_ASSEMBLY <> 0 AND

Line 2222: UPDATE WIP_REQUIREMENT_OPERATIONS w

2218:
2219:
2220: stmt_num := 120;
2221:
2222: UPDATE WIP_REQUIREMENT_OPERATIONS w
2223: SET RELIEVED_MATL_SCRAP_QUANTITY =
2224: (SELECT
2225: nvl(w.RELIEVED_MATL_SCRAP_QUANTITY,0) +
2226: decode(w2.RELIEVED_MATL_SCRAP_QUANTITY,

Line 2236: WIP_REQUIREMENT_OPERATIONS w2

2232: decode(l_include_comp_yield,
2233: 1, nvl(w2.component_yield_factor,1),
2234: 1)))
2235: FROM
2236: WIP_REQUIREMENT_OPERATIONS w2
2237: where
2238: w.WIP_ENTITY_ID = w2.WIP_ENTITY_ID AND
2239: w.INVENTORY_ITEM_ID = w2.INVENTORY_ITEM_ID AND
2240: w.OPERATION_SEQ_NUM = w2.OPERATION_SEQ_NUM AND