eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPACWC dependencies on WIP_REQUIREMENT_OPERATIONS

Line 60: wip_requirement_operations wro

56: inventory_item_id,
57: operation_seq_num,
58: wip_supply_type
59: FROM
60: wip_requirement_operations wro
61: WHERE
62: --
63: -- Exclude bulk, supplier, phantom
64: --

Line 82: wip_requirement_operations wro

78: inventory_item_id,
79: operation_seq_num,
80: wip_supply_type
81: FROM
82: wip_requirement_operations wro
83: WHERE
84: wro.wip_entity_id = i_wip_entity_id AND
85: wro.organization_id = i_org_id ;
86:

Line 206: from wip_requirement_operations

202: /* Commented for Bug6734270.If there is a resource added manually
203: then also the l_use_val_cost_type should be 1
204: select count(*)
205: into l_qty_per_assy
206: from wip_requirement_operations
207: where wip_entity_id = i_wip_entity_id
208: and quantity_per_assembly <>0;
209: */
210: SELECT count(1)

Line 214: FROM wip_requirement_operations wro

210: SELECT count(1)
211: INTO l_qty_per_assy
212: FROM dual
213: WHERE EXISTS ( SELECT NULL
214: FROM wip_requirement_operations wro
215: WHERE wro.wip_entity_id = i_wip_entity_id
216: AND wro.quantity_per_assembly <>0
217: UNION ALL
218: SELECT NULL

Line 366: UPDATE wip_requirement_operations w

362: END;
363:
364:
365: stmt_num := 102;
366: UPDATE wip_requirement_operations w
367: SET
368: relieved_matl_completion_qty =
369: (SELECT
370: nvl(quantity_issued,0)-

Line 374: FROM wip_requirement_operations w2

370: nvl(quantity_issued,0)-
371: nvl(relieved_matl_final_comp_qty,0)-
372: nvl(relieved_matl_scrap_quantity,0) +
373: l_future_issued_qty /* for bug 4246122 */
374: FROM wip_requirement_operations w2
375: WHERE
376: w.wip_entity_id = w2.wip_entity_id AND
377: w.organization_id = w2.organization_id AND
378: w.inventory_item_id = w2.inventory_item_id AND

Line 404: UPDATE wip_requirement_operations w

400:
401: stmt_num := 105;
402: /* New final completion algorithm */
403: /* when net is -ve */
404: UPDATE wip_requirement_operations w
405: SET
406: relieved_matl_final_comp_qty =
407: (SELECT
408: nvl(quantity_issued,0)-

Line 412: FROM wip_requirement_operations w2

408: nvl(quantity_issued,0)-
409: nvl(relieved_matl_completion_qty,0)-
410: nvl(relieved_matl_scrap_quantity,0) +
411: l_future_issued_qty /* for bug 4246122 */
412: FROM wip_requirement_operations w2
413: WHERE
414: w.wip_entity_id = w2.wip_entity_id AND
415: w.organization_id = w2.organization_id AND
416: w.inventory_item_id = w2.inventory_item_id AND

Line 916: UPDATE wip_requirement_operations w

912: l_future_issued_qty := 0;
913: END;
914:
915: stmt_num :=170;
916: UPDATE wip_requirement_operations w
917: SET
918: relieved_matl_completion_qty =
919: (SELECT
920: nvl(quantity_issued,0)-

Line 924: FROM wip_requirement_operations w2

920: nvl(quantity_issued,0)-
921: nvl(relieved_matl_final_comp_qty,0)-
922: nvl(relieved_matl_scrap_quantity,0)
923: + l_future_issued_qty
924: FROM wip_requirement_operations w2
925: WHERE
926: w.wip_entity_id = w2.wip_entity_id AND
927: w.organization_id = w2.organization_id AND
928: w.inventory_item_id = w2.inventory_item_id AND

Line 1299: WIP_REQUIREMENT_OPERATIONS WRO,

1295: i_prog_id,
1296: i_prog_appl_id,
1297: SYSDATE
1298: from
1299: WIP_REQUIREMENT_OPERATIONS WRO,
1300: CST_LAYER_COST_DETAILS CLCD,
1301: CST_QUANTITY_LAYERS CQL
1302: WHERE
1303: WRO.WIP_ENTITY_ID = i_wip_entity_id AND

Line 1632: wip_requirement_operations wro,

1628: 4,cql.outside_processing_cost,
1629: 5,cql.overhead_cost),0)))
1630: FROM
1631: wip_req_operation_cost_details w2,
1632: wip_requirement_operations wro,
1633: cst_quantity_layers cql
1634: WHERE
1635: w2.wip_entity_id = w1.wip_entity_id AND
1636: w2.organization_id = w1.organization_id AND

Line 1662: UPDATE wip_requirement_operations w1

1658:
1659:
1660: stmt_num := 270;
1661:
1662: UPDATE wip_requirement_operations w1
1663: SET
1664: relieved_matl_completion_qty =
1665: (SELECT
1666: nvl(w1.relieved_matl_completion_qty,0) +

Line 1675: wip_requirement_operations w2

1671: decode(l_include_comp_yield,
1672: 1, nvl(component_yield_factor,1),
1673: 1))
1674: FROM
1675: wip_requirement_operations w2
1676: WHERE
1677: w1.wip_entity_id = w2.wip_entity_id AND
1678: w1.organization_id = w2.organization_id AND
1679: w1.inventory_item_id = w2.inventory_item_id AND

Line 3578: from wip_requirement_operations

3574: /* Commented for Bug6734270.If there is a resource added manually
3575: then also the l_use_val_cost_type should be 1
3576: select count(*)
3577: into l_qty_per_assy
3578: from wip_requirement_operations
3579: where wip_entity_id = i_wip_entity_id
3580: and quantity_per_assembly <>0;
3581: */
3582: SELECT COUNT(1)

Line 3586: FROM wip_requirement_operations wro

3582: SELECT COUNT(1)
3583: INTO l_qty_per_assy
3584: FROM dual
3585: WHERE EXISTS ( SELECT NULL
3586: FROM wip_requirement_operations wro
3587: WHERE wro.wip_entity_id = i_wip_entity_id
3588: AND wro.quantity_per_assembly <>0
3589: UNION ALL
3590: SELECT NULL

Line 3892: UPDATE wip_requirement_operations w1

3888: w1.organization_id = i_org_id;
3889:
3890: stmt_num := 107;
3891:
3892: UPDATE wip_requirement_operations w1
3893: SET
3894: relieved_matl_completion_qty =
3895: (SELECT
3896: --

Line 3909: wip_requirement_operations w2,

3905: prior_completion_quantity)),
3906: 0)
3907: FROM
3908: wip_req_operation_cost_details wrocd,
3909: wip_requirement_operations w2,
3910: cst_comp_snapshot cocd
3911: WHERE
3912: w1.wip_entity_id = w2.wip_entity_id AND
3913: w1.inventory_item_id = w2.inventory_item_id AND

Line 4034: wip_requirement_operations wro

4030: 0)),
4031: 0)))
4032: FROM
4033: wip_req_operation_cost_details w2,
4034: wip_requirement_operations wro
4035: WHERE
4036: w1.wip_entity_id = w2.wip_entity_id AND
4037: w1.organization_id = w2.organization_id AND
4038: w1.operation_seq_num = w2.operation_seq_num AND

Line 4053: wip_requirement_operations wro2

4049: (SELECT
4050: wip_entity_id, organization_id,
4051: inventory_item_id,operation_seq_num
4052: FROM
4053: wip_requirement_operations wro2
4054: WHERE
4055: wro2.wip_entity_id = i_wip_entity_id AND
4056: wro2.organization_id = i_org_id AND
4057: wro2.quantity_per_assembly <> 0);

Line 4061: UPDATE wip_requirement_operations w

4057: wro2.quantity_per_assembly <> 0);
4058:
4059: stmt_num := 117;
4060:
4061: UPDATE wip_requirement_operations w
4062: SET relieved_matl_completion_qty =
4063: (SELECT
4064: NVL(w.relieved_matl_completion_qty,0)+
4065: DECODE(w.relieved_matl_completion_qty,0,

Line 4100: wip_requirement_operations w2

4096: 0)),
4097: 0)))
4098: FROM
4099: wip_req_operation_cost_details wrocd,
4100: wip_requirement_operations w2
4101: WHERE
4102: w.wip_entity_id = w2.wip_entity_id AND
4103: w.inventory_item_id = w2.inventory_item_id AND
4104: w.operation_seq_num = w2.operation_seq_num AND