APPS.CSTPSMUT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 3096: wip_requirement_operations WRO,

3092: x_pl_res_cost,
3093: x_pl_osp_cost,
3094: x_pl_ovh_cost
3095: FROM
3096: wip_requirement_operations WRO,
3097: cst_item_costs CIC
3098: WHERE
3099: CIC.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID
3100: AND WRO.ORGANIZATION_ID = p_org_id

Line 3494: UPDATE wip_requirement_operations wro

3490: /* Update quantity issued. */
3491:
3492: l_stmt_num := 50;
3493:
3494: UPDATE wip_requirement_operations wro
3495: SET costed_quantity_issued = ROUND((C_result.start_quantity *
3496: DECODE(nvl(wro.basis_type,1),
3497: 2, wro.quantity_per_assembly/C_result.start_quantity,
3498: wro.quantity_per_assembly) /

Line 3636: UPDATE wip_requirement_operations wro

3632: AND wor2.resource_seq_num = wor.resource_seq_num);
3633:
3634: l_stmt_num := 75;
3635:
3636: UPDATE wip_requirement_operations wro
3637: SET wro.costed_quantity_issued =
3638: ( SELECT (NVL(wro1.costed_quantity_issued,0) - DECODE(sign(NVL(WRO1.COSTED_QUANTITY_RELIEVED, 0)), 1, NVL(WRO1.COSTED_QUANTITY_RELIEVED, 0), 0) )*
3639: /* LBM changes (This is cond like basis_type<>2 or l_txn_type=1) Bugs 5202282*/
3640: decode(l_txn_type, 1, l_scale_factor, decode(nvl(wro.basis_type,1), 2, 1, l_scale_factor)) *

Line 3643: FROM wip_requirement_operations wro1

3639: /* LBM changes (This is cond like basis_type<>2 or l_txn_type=1) Bugs 5202282*/
3640: decode(l_txn_type, 1, l_scale_factor, decode(nvl(wro.basis_type,1), 2, 1, l_scale_factor)) *
3641: DECODE(sign(nvl(wro1.costed_quantity_issued,0) - DECODE(sign(NVL(WRO1.COSTED_QUANTITY_RELIEVED, 0)), 1, NVL(WRO1.COSTED_QUANTITY_RELIEVED, 0), 0)),
3642: 1, 1, 0)
3643: FROM wip_requirement_operations wro1
3644: WHERE wro1.wip_entity_id = l_rep_wip_entity_id
3645: AND wro1.inventory_item_id = wro.inventory_item_id
3646: AND wro1.organization_id = wro.organization_id
3647: AND wro1.operation_seq_num = wro.operation_seq_num )

Line 3659: from wip_requirement_operations wro2

3655: and wo.operation_seq_num = wro.operation_seq_num
3656: and wo.disable_date <= l_transaction_date )
3657: /* Make sure the operation exists in the Parent */
3658: AND exists (select 'operation exists'
3659: from wip_requirement_operations wro2
3660: WHERE wro2.wip_entity_id = l_rep_wip_entity_id
3661: AND wro2.inventory_item_id = wro.inventory_item_id
3662: AND wro2.organization_id = wro.organization_id
3663: AND wro2.operation_seq_num = wro.operation_seq_num );

Line 3837: UPDATE wip_requirement_operations wro

3833: AND nvl(wor.applied_resource_units, 0) >= nvl(wor.relieved_res_units, 0)
3834: AND nvl(wor.applied_resource_value, 0) >= nvl(wor.relieved_res_value, 0)
3835: AND (wor.basis_type <> 2 or l_txn_type = 1 );
3836:
3837: UPDATE wip_requirement_operations wro
3838: SET wro.costed_quantity_issued = (NVL(wro.costed_quantity_issued, 0) -
3839: DECODE(sign(NVL(WRO.COSTED_QUANTITY_RELIEVED, 0)), 1, NVL(WRO.COSTED_QUANTITY_RELIEVED, 0), 0))
3840: * l_resulting_scale_factor +
3841: DECODE(sign(NVL(WRO.COSTED_QUANTITY_RELIEVED, 0)), 1, NVL(WRO.COSTED_QUANTITY_RELIEVED, 0), 0)

Line 3958: UPDATE wip_requirement_operations wro

3954: and wo.disable_date <= l_transaction_date );
3955:
3956: l_stmt_num := 130;
3957:
3958: UPDATE wip_requirement_operations wro
3959: SET costed_quantity_issued = round(DECODE(sign(NVL(WRO.COSTED_QUANTITY_RELIEVED, 0)), 1, NVL(WRO.COSTED_QUANTITY_RELIEVED, 0), 0),6)
3960: WHERE wip_entity_id = S_rec.wip_entity_id
3961: AND nvl(costed_quantity_issued, 0) >= nvl(costed_quantity_relieved, 0)
3962: AND not exists (select 'obsolete operation'