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.CSTPSMUT dependencies on WIP_OPERATION_OVERHEADS

Line 12: -- This function inserts records in WIP_OPERATION_OVERHEADS for

8: -- FUNCTION --
9: -- INSERT_WOO
10: -- --
11: -- DESCRIPTION --
12: -- This function inserts records in WIP_OPERATION_OVERHEADS for
13: -- newly created jobs during Split/Merge/Bonus
14: --
15: -- --
16: -- PURPOSE: --

Line 47: INSERT INTO WIP_OPERATION_OVERHEADS

43: IF (l_debug_flag = 'Y') THEN
44: FND_FILE.PUT_LINE (FND_FILE.LOG, 'INSERT_WOO <<<');
45: END IF;
46:
47: INSERT INTO WIP_OPERATION_OVERHEADS
48: (WIP_ENTITY_ID,
49: OPERATION_SEQ_NUM,
50: RESOURCE_SEQ_NUM,
51: ORGANIZATION_ID,

Line 114: FROM wip_operation_overheads woo

110: AND WO.operation_seq_num = WOR.operation_seq_num
111: AND WO.operation_seq_num <= p_operation_seq_num
112: /* Don't insert if a row already exists 5364135 */
113: AND NOT EXISTS (SELECT 'Not exists'
114: FROM wip_operation_overheads woo
115: WHERE woo.wip_entity_id = WO.wip_entity_id
116: AND woo.operation_seq_num = WO.operation_seq_num
117: AND woo.resource_seq_num = WOR.resource_seq_num
118: AND woo.organization_id = WO.organization_id

Line 158: FROM wip_operation_overheads woo

154: AND WO.organization_id = p_organization_id
155: AND WO.operation_seq_num <= p_operation_seq_num
156: /* Don't insert if a row already exists 5364135 */
157: AND NOT EXISTS (SELECT 'Not exists'
158: FROM wip_operation_overheads woo
159: WHERE woo.wip_entity_id = WO.wip_entity_id
160: AND woo.operation_seq_num = WO.operation_seq_num
161: AND woo.resource_seq_num = -1
162: AND woo.organization_id = WO.organization_id

Line 3243: /* For non bonus transactions use WIP_OPERATION_OVERHEADS to calculate overheads */

3239: AND CDO.cost_type_id = 1;
3240:
3241: x_tl_ovh_cost := x_tl_ovh_cost + l_tl_ovh_dept_cost;
3242:
3243: /* For non bonus transactions use WIP_OPERATION_OVERHEADS to calculate overheads */
3244:
3245: ELSE
3246: SELECT nvl(DECODE(p_run_mode,
3247: 1, SUM(NVL(WOO.applied_ovhd_value,0)),

Line 3250: FROM wip_operation_overheads WOO,

3246: SELECT nvl(DECODE(p_run_mode,
3247: 1, SUM(NVL(WOO.applied_ovhd_value,0)),
3248: 2, SUM(NVL(WOO.relieved_ovhd_value,0))),0)
3249: INTO x_tl_ovh_cost
3250: FROM wip_operation_overheads WOO,
3251: cst_resource_overheads CRO,
3252: wip_operation_resources WOR
3253: WHERE
3254: WOO.operation_seq_num <= l_operation_seq_num

Line 3278: FROM wip_operation_overheads WOO

3274: SELECT nvl(DECODE(p_run_mode,
3275: 1, SUM(NVL(WOO.applied_ovhd_value,0)),
3276: 2, SUM(NVL(WOO.relieved_ovhd_value,0))),0)
3277: INTO l_tl_ovh_dept_cost
3278: FROM wip_operation_overheads WOO
3279: WHERE
3280: WOO.operation_seq_num <= l_operation_seq_num
3281: AND WOO.wip_entity_id = p_entity_id
3282: AND WOO.organization_id = p_org_id

Line 3511: UPDATE wip_operation_overheads woo

3507:
3508: l_stmt_num := 55;
3509:
3510: /* Resource Unit and Value Based Overheads */
3511: UPDATE wip_operation_overheads woo
3512: SET ( applied_ovhd_units,
3513: applied_ovhd_value ) =
3514: ( SELECT decode(woo.basis_type,
3515: 3, NVL(WOR.applied_resource_units,0),

Line 3551: UPDATE wip_operation_overheads woo

3547: l_stmt_num := 58;
3548:
3549: /* Department Based Overheads */
3550:
3551: UPDATE wip_operation_overheads woo
3552: SET ( applied_ovhd_units,
3553: applied_ovhd_value ) =
3554: ( SELECT decode(woo.basis_type, 1, C_result.start_quantity,
3555: 2, 1),

Line 3679: UPDATE wip_operation_overheads woo

3675: applied_ovhd_value = CDO.rate_or_amount * applied_ovhd_units
3676: */
3677:
3678: /* For Item and Lot based Ovhd's, Initialize the Ovhd's */
3679: UPDATE wip_operation_overheads woo
3680: SET ( woo.applied_ovhd_units,
3681: woo.applied_ovhd_value ) =
3682: ( SELECT (NVL(woo1.applied_ovhd_units,0) - DECODE(sign(nvl(woo1.relieved_ovhd_units, 0)), 1, nvl(woo1.relieved_ovhd_units, 0), 0) ) *
3683: DECODE(sign(nvl(woo1.applied_ovhd_units,0) - DECODE(sign(nvl(woo1.relieved_ovhd_units, 0)), 1, nvl(woo1.relieved_ovhd_units, 0), 0)),

Line 3688: FROM wip_operation_overheads woo1

3684: 1, 1, 0),
3685: (NVL(woo1.applied_ovhd_value,0) - DECODE(sign(nvl(woo1.relieved_ovhd_value, 0)), 1, nvl(woo1.relieved_ovhd_value, 0), 0) ) *
3686: DECODE(sign(nvl(woo1.applied_ovhd_value,0) - DECODE(sign(nvl(woo1.relieved_ovhd_value, 0)), 1, nvl(woo1.relieved_ovhd_value, 0), 0)),
3687: 1, 1, 0)
3688: FROM wip_operation_overheads woo1
3689: WHERE woo1.wip_entity_id = l_rep_wip_entity_id
3690: AND woo1.overhead_id = woo.overhead_id
3691: AND woo1.organization_id = woo.organization_id
3692: AND woo1.operation_seq_num = woo.operation_seq_num

Line 3706: from wip_operation_overheads woo2

3702: and wo.disable_date <= l_transaction_date )
3703: AND woo.basis_type in (1,2)
3704: /* Make sure the operation and overhead exist in the Parent */
3705: AND exists (select 'operation exists'
3706: from wip_operation_overheads woo2
3707: WHERE woo2.wip_entity_id = l_rep_wip_entity_id
3708: AND woo2.overhead_id = woo.overhead_id
3709: AND woo2.organization_id = woo.organization_id
3710: AND woo2.operation_seq_num = woo.operation_seq_num

Line 3749: UPDATE wip_operation_overheads woo

3745: /* For Item and Lot based Ovhds, scale them depending on Txn Type
3746: Lot based ovhds not scaled for merge/update_qty
3747: */
3748:
3749: UPDATE wip_operation_overheads woo
3750: SET woo.applied_ovhd_units = woo.applied_ovhd_units * l_scale_factor,
3751: woo.applied_ovhd_value = woo.applied_ovhd_value * l_scale_factor
3752: WHERE woo.wip_entity_id = C_rec1.wip_entity_id
3753: AND woo.organization_id = l_org_id

Line 3768: UPDATE wip_operation_overheads woo

3764: /* Update WOO for Resource Unit and Value based Ovhds */
3765:
3766: l_stmt_num := 98;
3767:
3768: UPDATE wip_operation_overheads woo
3769: SET ( applied_ovhd_units,
3770: applied_ovhd_value ) =
3771: ( SELECT decode(woo.basis_type,
3772: 3, NVL(WOR.applied_resource_units,0),

Line 3853: UPDATE wip_operation_overheads woo

3849: AND nvl(wro.costed_quantity_issued, 0) >= nvl(wro.costed_quantity_relieved, 0)
3850: AND (nvl(wro.basis_type,1) <> 2 or l_txn_type = 1 ); /* LBM Changes for Merge Bug 5202282 */
3851:
3852: /* Update WOO in a similar manner */
3853: UPDATE wip_operation_overheads woo
3854: SET applied_ovhd_units =
3855: (NVL(woo.applied_ovhd_units, 0) - DECODE(sign(nvl(relieved_ovhd_units, 0)), 1, nvl(relieved_ovhd_units, 0), 0)) * l_resulting_scale_factor
3856: + DECODE(sign(nvl(relieved_ovhd_units, 0)), 1, nvl(relieved_ovhd_units, 0), 0),
3857: applied_ovhd_value =

Line 3873: UPDATE wip_operation_overheads woo

3869: AND (NVL(woo.applied_ovhd_value, 0) - NVL(relieved_ovhd_value, 0)) >= 0
3870: AND (woo.basis_type <> 2 or l_txn_type = 1 )
3871: AND woo.basis_type in (1, 2);
3872:
3873: UPDATE wip_operation_overheads woo
3874: SET ( applied_ovhd_units,
3875: applied_ovhd_value ) =
3876: (SELECT decode(woo.basis_type,
3877: 3, NVL(WOR.applied_resource_units,0),

Line 3972: UPDATE wip_operation_overheads woo

3968:
3969:
3970:
3971: l_stmt_num := 135;
3972: UPDATE wip_operation_overheads woo
3973: SET applied_ovhd_units = DECODE(sign(nvl(relieved_ovhd_units, 0)), 1, nvl(relieved_ovhd_units, 0), 0),
3974: applied_ovhd_value = DECODE(sign(nvl(relieved_ovhd_value, 0)), 1, nvl(relieved_ovhd_value, 0), 0)
3975: WHERE woo.wip_entity_id = S_rec.wip_entity_id
3976: AND woo.organization_id= l_org_id