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 1682: wip_requirement_operations wro,

1678: 4,cql.outside_processing_cost,
1679: 5,cql.overhead_cost),0)))
1680: FROM
1681: wip_req_operation_cost_details w2,
1682: wip_requirement_operations wro,
1683: cst_quantity_layers cql
1684: WHERE
1685: w2.wip_entity_id = w1.wip_entity_id AND
1686: w2.organization_id = w1.organization_id AND

Line 1712: UPDATE wip_requirement_operations w1

1708:
1709:
1710: stmt_num := 270;
1711:
1712: UPDATE wip_requirement_operations w1
1713: SET
1714: relieved_matl_completion_qty =
1715: (SELECT
1716: nvl(w1.relieved_matl_completion_qty,0) +

Line 1725: wip_requirement_operations w2

1721: decode(l_include_comp_yield,
1722: 1, nvl(component_yield_factor,1),
1723: 1))
1724: FROM
1725: wip_requirement_operations w2
1726: WHERE
1727: w1.wip_entity_id = w2.wip_entity_id AND
1728: w1.organization_id = w2.organization_id AND
1729: w1.inventory_item_id = w2.inventory_item_id AND

Line 3743: from wip_requirement_operations

3739: /* Commented for Bug6734270.If there is a resource added manually
3740: then also the l_use_val_cost_type should be 1
3741: select count(*)
3742: into l_qty_per_assy
3743: from wip_requirement_operations
3744: where wip_entity_id = i_wip_entity_id
3745: and quantity_per_assembly <>0;
3746: */
3747: SELECT COUNT(1)

Line 3751: FROM wip_requirement_operations wro

3747: SELECT COUNT(1)
3748: INTO l_qty_per_assy
3749: FROM dual
3750: WHERE EXISTS ( SELECT NULL
3751: FROM wip_requirement_operations wro
3752: WHERE wro.wip_entity_id = i_wip_entity_id
3753: AND wro.quantity_per_assembly <>0
3754: UNION ALL
3755: SELECT NULL

Line 4039: wip_requirement_operations wro,

4035: prior_completion_quantity)),
4036: 0)
4037: FROM
4038: wip_req_operation_cost_details w2,
4039: wip_requirement_operations wro,
4040: cst_comp_snapshot cocd
4041: WHERE
4042: w1.wip_entity_id = w2.wip_entity_id AND
4043: w1.organization_id = w2.organization_id AND

Line 4063: UPDATE wip_requirement_operations w1

4059: w1.organization_id = i_org_id;
4060:
4061: stmt_num := 107;
4062:
4063: UPDATE wip_requirement_operations w1
4064: SET
4065: relieved_matl_completion_qty =
4066: (SELECT
4067: --

Line 4080: wip_requirement_operations w2,

4076: prior_completion_quantity)),
4077: 0)
4078: FROM
4079: wip_req_operation_cost_details wrocd,
4080: wip_requirement_operations w2,
4081: cst_comp_snapshot cocd
4082: WHERE
4083: w1.wip_entity_id = w2.wip_entity_id AND
4084: w1.inventory_item_id = w2.inventory_item_id AND

Line 4206: wip_requirement_operations wro

4202: 0)),
4203: 0)))
4204: FROM
4205: wip_req_operation_cost_details w2,
4206: wip_requirement_operations wro
4207: WHERE
4208: w1.wip_entity_id = w2.wip_entity_id AND
4209: w1.organization_id = w2.organization_id AND
4210: w1.operation_seq_num = w2.operation_seq_num AND

Line 4225: wip_requirement_operations wro2

4221: (SELECT
4222: wip_entity_id, organization_id,
4223: inventory_item_id,operation_seq_num
4224: FROM
4225: wip_requirement_operations wro2
4226: WHERE
4227: wro2.wip_entity_id = i_wip_entity_id AND
4228: wro2.organization_id = i_org_id AND
4229: wro2.quantity_per_assembly <> 0);

Line 4233: UPDATE wip_requirement_operations w

4229: wro2.quantity_per_assembly <> 0);
4230:
4231: stmt_num := 117;
4232:
4233: UPDATE wip_requirement_operations w
4234: SET relieved_matl_completion_qty =
4235: (SELECT
4236: NVL(w.relieved_matl_completion_qty,0)+
4237: DECODE(w.relieved_matl_completion_qty,0,

Line 4272: wip_requirement_operations w2

4268: 0)),
4269: 0)))
4270: FROM
4271: wip_req_operation_cost_details wrocd,
4272: wip_requirement_operations w2
4273: WHERE
4274: w.wip_entity_id = w2.wip_entity_id AND
4275: w.inventory_item_id = w2.inventory_item_id AND
4276: w.operation_seq_num = w2.operation_seq_num AND