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 1184: from wip_requirement_operations WRO,

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

Line 1201: from wip_requirement_operations WRO

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

Line 1329: from wip_requirement_operations

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

Line 1338: FROM wip_requirement_operations wro

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

Line 1589: from wip_requirement_operations WRO

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

Line 1605: update wip_requirement_operations WRO

1601:
1602:
1603:
1604: -- update WRO
1605: update wip_requirement_operations WRO
1606: set relieved_matl_completion_qty
1607: =
1608: (
1609: select

Line 1690: from wip_requirement_operations WRO

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

Line 1701: UPDATE wip_requirement_operations w1

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

Line 1712: wip_requirement_operations w2

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