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.CSTPLCAC dependencies on WIP_REQUIREMENT_OPERATIONS

Line 61: from wip_requirement_operations WRO

57: DECODE(l_include_comp_yield,
58: 1, nvl(WRO.component_yield_factor,1),
59: 1) quantity_per_assembly,
60: WRO.component_yield_factor
61: from wip_requirement_operations WRO
62: where WRO.wip_entity_id = i_wip_entity_id and
63: WRO.wip_supply_type not in (4,5,6) and
64: WRO.quantity_per_assembly <> 0;
65:

Line 223: FROM wip_requirement_operations

219: should be 1
220:
221: SELECT COUNT(*)
222: INTO l_wro_count
223: FROM wip_requirement_operations
224: WHERE wip_entity_id = i_wip_entity_id
225: AND organization_id = i_org_id
226: AND quantity_per_assembly <> 0;
227: */

Line 233: FROM wip_requirement_operations wro

229: SELECT COUNT(1)
230: INTO l_wro_count
231: FROM dual
232: WHERE EXISTS ( SELECT NULL
233: FROM wip_requirement_operations wro
234: WHERE wro.wip_entity_id = i_wip_entity_id
235: AND wro.quantity_per_assembly <>0
236: UNION ALL
237: SELECT NULL

Line 592: from wip_requirement_operations WRO

588: (
589: select wip_entity_id,
590: operation_seq_num,
591: inventory_item_id
592: from wip_requirement_operations WRO
593: where
594: WRO.wip_entity_id = i_wip_entity_id and
595: /* Restrict only to the current Item */
596: WRO.operation_seq_num = wro_rec.operation_seq_num and

Line 608: update wip_requirement_operations WRO

604:
605: /* Update WRO record for this item. */
606:
607: -- update WRO
608: update wip_requirement_operations WRO
609: set relieved_matl_completion_qty
610: =
611: (
612: select

Line 693: from wip_requirement_operations WRO

689: ) AND
690: EXISTS
691: (
692: select 'x'
693: from wip_requirement_operations WRO
694: where WRO.wip_entity_id = i_wip_entity_id and
695: WRO.operation_seq_num = wro_rec.operation_seq_num and
696: WRO.inventory_item_id = wro_rec.inventory_item_id and
697: WRO.wip_supply_type not in (4, 5, 6)

Line 704: UPDATE wip_requirement_operations w1

700: CCE.cost_element_id;
701:
702: /* Changed as part of LBM project. Added decode to qpa for Lot Based Materials */
703:
704: UPDATE wip_requirement_operations w1
705: SET
706: relieved_matl_completion_qty =
707: (SELECT
708: nvl(w1.relieved_matl_completion_qty,0) +

Line 715: wip_requirement_operations w2

711: decode(l_include_comp_yield,
712: 1, nvl(w2.component_yield_factor,1),
713: 1))
714: FROM
715: wip_requirement_operations w2
716: WHERE
717: w1.wip_entity_id = w2.wip_entity_id AND
718: w1.organization_id = w2.organization_id AND
719: w1.inventory_item_id = w2.inventory_item_id AND

Line 1186: from wip_requirement_operations WRO,

1182: 1) quantity_per_assembly,
1183: WRO.relieved_matl_completion_qty,
1184: decode( nvl( CCS.prior_completion_quantity, 0 ), 0, 1,
1185: i_txn_qty / CCS.prior_completion_quantity ) component_ratio
1186: from wip_requirement_operations WRO,
1187: cst_comp_snapshot CCS
1188: where WRO.wip_entity_id = i_wip_entity_id and
1189: WRO.wip_supply_type not in (4,5,6) and
1190: WRO.quantity_per_assembly <> 0 and

Line 1204: from wip_requirement_operations WRO

1200: WRO.quantity_per_assembly,
1201: WRO.relieved_matl_completion_qty,
1202: decode( nvl( WRO.relieved_matl_completion_qty, 0 ), 0, 1,
1203: i_txn_qty /l_prior_completed_qty ) component_ratio
1204: from wip_requirement_operations WRO
1205: where WRO.wip_entity_id = i_wip_entity_id and
1206: WRO.wip_supply_type not in (4,5,6) and
1207: WRO.quantity_per_assembly <> 0 and
1208: NOT EXISTS ( select 'Exists'

Line 1332: from wip_requirement_operations

1328: added manually then also the l_use_val_cost_type
1329: should be 1
1330: select count(*)
1331: into l_wro_count
1332: from wip_requirement_operations
1333: where wip_entity_id = i_wip_entity_id
1334: and organization_id = i_org_id
1335: and quantity_per_assembly <>0;
1336: */

Line 1341: FROM wip_requirement_operations wro

1337: SELECT COUNT(1)
1338: INTO l_wro_count
1339: FROM dual
1340: WHERE EXISTS ( SELECT NULL
1341: FROM wip_requirement_operations wro
1342: WHERE wro.wip_entity_id = i_wip_entity_id
1343: AND wro.quantity_per_assembly <>0
1344: UNION ALL
1345: SELECT NULL

Line 1592: from wip_requirement_operations WRO

1588: (
1589: select wip_entity_id,
1590: operation_seq_num,
1591: inventory_item_id
1592: from wip_requirement_operations WRO
1593: where
1594: WRO.wip_entity_id = i_wip_entity_id and
1595: /* Restrict only to the current Item */
1596: WRO.operation_seq_num = wro_rec.operation_seq_num and

Line 1608: update wip_requirement_operations WRO

1604:
1605:
1606:
1607: -- update WRO
1608: update wip_requirement_operations WRO
1609: set relieved_matl_completion_qty
1610: =
1611: (
1612: select

Line 1693: from wip_requirement_operations WRO

1689: ) AND
1690: EXISTS
1691: (
1692: select 'x'
1693: from wip_requirement_operations WRO
1694: where WRO.wip_entity_id = i_wip_entity_id and
1695: WRO.operation_seq_num = wro_rec.operation_seq_num and
1696: WRO.inventory_item_id = wro_rec.inventory_item_id and
1697: WRO.wip_supply_type not in (4, 5, 6)

Line 1704: UPDATE wip_requirement_operations w1

1700: CCE.cost_element_id;
1701:
1702: /* Changed for LBM project. Added decode to qpa for Lot Based Materials */
1703:
1704: UPDATE wip_requirement_operations w1
1705: SET
1706: relieved_matl_completion_qty =
1707: (SELECT
1708: nvl(w1.relieved_matl_completion_qty,0) +

Line 1715: wip_requirement_operations w2

1711: DECODE(l_include_comp_yield,
1712: 1, nvl(w2.component_yield_factor,1),
1713: 1))
1714: FROM
1715: wip_requirement_operations w2
1716: WHERE
1717: w1.wip_entity_id = w2.wip_entity_id AND
1718: w1.organization_id = w2.organization_id AND
1719: w1.inventory_item_id = w2.inventory_item_id AND