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_OPERATIONS

Line 97: wip_operations WO

93: FROM
94: cst_department_overheads CDO,
95: cst_resource_overheads CRO,
96: wip_operation_resources WOR,
97: wip_operations WO
98: WHERE
99: WO.wip_entity_id = p_wip_entity_id
100: AND WOR.wip_entity_id = WO.wip_entity_id
101: AND WOR.organization_id = WO.organization_id

Line 147: wip_operations WO

143: sysdate,
144: sysdate
145: FROM
146: cst_department_overheads CDO,
147: wip_operations WO
148: WHERE
149: WO.wip_entity_id = p_wip_entity_id
150: AND CDO.department_id = WO.department_id
151: AND CDO.organization_id = WO.organization_id

Line 2464: FROM WIP_OPERATIONS WO,

2460: IF l_operation_seq_num IS NULL THEN
2461: l_stmt_num := 52;
2462: SELECT wo.operation_seq_num
2463: INTO l_operation_seq_num
2464: FROM WIP_OPERATIONS WO,
2465: WSM_SM_RESULTING_JOBS WSRJ,
2466: BOM_OPERATION_SEQUENCES BOS
2467: WHERE WSRJ.transaction_id = p_transaction_id
2468: AND nvl(wsrj.starting_intraoperation_step, 1) = 1

Line 2491: FROM wip_operations

2487: l_stmt_num := 55;
2488:
2489: SELECT min(operation_seq_num)
2490: INTO l_min_op_seq_num
2491: FROM wip_operations
2492: WHERE wip_entity_id = l_wip_entity_id
2493: AND organization_id = l_organization_id;
2494:
2495:

Line 2971: FROM wip_operations

2967: l_stmt_num := 10;
2968:
2969: SELECT operation_seq_num
2970: INTO l_first_op_seq_num
2971: FROM wip_operations
2972: WHERE wip_entity_id = p_entity_id
2973: AND previous_operation_seq_num is null;
2974:
2975: l_operation_seq_num := p_operation_seq_num;

Line 3004: FROM wip_operations

3000: calculate charges upto previous op seq num */
3001: if(p_txn_type = 4) then
3002: SELECT MAX( OPERATION_SEQ_NUM )
3003: INTO l_operation_seq_num
3004: FROM wip_operations
3005: WHERE wip_entity_id = p_entity_id
3006: AND operation_seq_num < p_operation_seq_num
3007: AND organization_id = p_org_id;
3008: end if;

Line 3112: from wip_operations WO

3108: (abs(nvl(WRO.COSTED_QUANTITY_ISSUED, 0)) >= abs(nvl(WRO.COSTED_QUANTITY_RELIEVED, 0)))) /* Added abs() for bug 6774122 */
3109: /* LBM Changes end*/
3110: AND ( WRO.WIP_SUPPLY_TYPE not in (2, 4, 5, 6) or p_txn_type <> 4 )
3111: AND not exists (select 'obsolete operation'
3112: from wip_operations WO
3113: where WO.wip_entity_id = WRO.wip_entity_id
3114: and WO.organization_id = WRO.organization_id
3115: and WO.operation_seq_num = WRO.operation_seq_num
3116: and WO.disable_date <= l_transaction_date );

Line 3169: from wip_operations WO

3165: AND (WOR.basis_type <> 2 or p_txn_type in (1, 4))
3166: AND ((p_txn_type = 4) OR
3167: nvl(WOR.applied_resource_value, 0) >= nvl(WOR.relieved_res_value, 0))
3168: AND not exists (select 'obsolete operation'
3169: from wip_operations WO
3170: where WO.wip_entity_id = WOR.wip_entity_id
3171: and WO.organization_id = WOR.organization_id
3172: and WO.operation_seq_num = WOR.operation_seq_num
3173: and WO.disable_date <= l_transaction_date );

Line 3199: wip_operations WO,

3195:
3196: INTO
3197: x_tl_ovh_cost
3198: FROM
3199: wip_operations WO,
3200: wip_operation_resources WOR,
3201: cst_resource_overheads CRO,
3202: cst_department_overheads CDO,
3203: bom_resources BR,

Line 3229: FROM wip_operations WO,

3225: SELECT NVL(SUM(NVL(DECODE(CDO.basis_type,
3226: 1,CDO.rate_or_amount,
3227: 2,CDO.rate_or_amount/p_lot_size),0)), 0)
3228: INTO l_tl_ovh_dept_cost
3229: FROM wip_operations WO,
3230: cst_department_overheads CDO
3231: WHERE
3232: WO.wip_entity_id = p_entity_id
3233: AND WO.operation_seq_num <= l_operation_seq_num

Line 3268: FROM wip_operations WO

3264: AND WOO.basis_type in (3, 4)
3265: AND nvl(WOR.applied_resource_value, 0) >= nvl(WOR.relieved_res_value, 0)
3266: AND not exists
3267: ( SELECT 1
3268: FROM wip_operations WO
3269: WHERE WO.DISABLE_DATE <= l_transaction_date
3270: AND WO.operation_seq_num = WOO.operation_seq_num
3271: AND WO.wip_entity_id = p_entity_id )
3272: AND ( WOR.basis_type <> 2 or p_txn_type = 1 );

Line 3286: FROM wip_operations WO

3282: AND WOO.organization_id = p_org_id
3283: AND WOO.basis_type in (1, 2)
3284: AND not exists
3285: ( SELECT 1
3286: FROM wip_operations WO
3287: WHERE WO.DISABLE_DATE <= l_transaction_date
3288: AND WO.operation_seq_num = WOO.operation_seq_num
3289: AND WO.wip_entity_id = p_entity_id )
3290: AND ( WOO.basis_type <> 2 or p_txn_type = 1 );

Line 3445: FROM WIP_OPERATIONS WO,

3441:
3442: IF l_operation_seq_num IS NULL THEN
3443: SELECT wo.operation_seq_num
3444: INTO l_operation_seq_num
3445: FROM WIP_OPERATIONS WO,
3446: WSM_SM_RESULTING_JOBS WSRJ,
3447: BOM_OPERATION_SEQUENCES BOS
3448: WHERE WSRJ.transaction_id = p_txn_id
3449: AND nvl(wsrj.starting_intraoperation_step, 1) = 1

Line 3524: wip_operations WO

3520: NVL(WOR.APPLIED_RESOURCE_VALUE,0), 0))
3521: FROM wip_operation_resources WOR,
3522: cst_resource_overheads CRO,
3523: cst_department_overheads CDO,
3524: wip_operations WO
3525: WHERE
3526: WOR.wip_entity_id = C_result.wip_entity_id
3527: AND WOR.organization_id = l_org_id
3528: AND WOR.operation_seq_num = WOO.operation_seq_num

Line 3558: FROM wip_operations WO,

3554: ( SELECT decode(woo.basis_type, 1, C_result.start_quantity,
3555: 2, 1),
3556: decode(woo.basis_type, 1, CDO.rate_or_amount * C_result.start_quantity,
3557: 2, CDO.rate_or_amount)
3558: FROM wip_operations WO,
3559: cst_department_overheads CDO
3560: WHERE
3561: woo.operation_seq_num = wo.operation_seq_num
3562: AND WO.wip_entity_id = C_result.wip_entity_id

Line 3621: from wip_operations wo

3617: WHERE wor.wip_entity_id = C_rec.wip_entity_id
3618: AND wor.organization_id = l_org_id
3619: AND wor.wip_entity_id <> l_rep_wip_entity_id
3620: AND not exists (select 'obsolete operation'
3621: from wip_operations wo
3622: where wo.wip_entity_id = wor.wip_entity_id
3623: and wo.organization_id = wor.organization_id
3624: and wo.operation_seq_num = wor.operation_seq_num
3625: and wo.disable_date <= l_transaction_date )

Line 3652: from wip_operations wo

3648: WHERE wro.wip_entity_id = C_rec.wip_entity_id
3649: AND wro.organization_id = l_org_id
3650: AND wro.wip_entity_id <> l_rep_wip_entity_id
3651: AND not exists (select 'obsolete operation'
3652: from wip_operations wo
3653: where wo.wip_entity_id = wro.wip_entity_id
3654: and wo.organization_id = wro.organization_id
3655: and wo.operation_seq_num = wro.operation_seq_num
3656: and wo.disable_date <= l_transaction_date )

Line 3698: from wip_operations wo

3694: WHERE woo.wip_entity_id = C_rec.wip_entity_id
3695: AND woo.organization_id = l_org_id
3696: AND woo.wip_entity_id <> l_rep_wip_entity_id
3697: AND not exists (select 'obsolete operation'
3698: from wip_operations wo
3699: where wo.wip_entity_id = woo.wip_entity_id
3700: and wo.organization_id = woo.organization_id
3701: and wo.operation_seq_num = woo.operation_seq_num
3702: and wo.disable_date <= l_transaction_date )

Line 3736: from wip_operations wo

3732: WHERE wor.wip_entity_id = C_rec1.wip_entity_id
3733: AND wor.organization_id = l_org_id
3734: AND wor.wip_entity_id <> l_rep_wip_entity_id
3735: AND not exists (select 'obsolete operation'
3736: from wip_operations wo
3737: where wo.wip_entity_id = wor.wip_entity_id
3738: and wo.organization_id = wor.organization_id
3739: and wo.operation_seq_num = wor.operation_seq_num
3740: and wo.disable_date <= l_transaction_date )

Line 3756: from wip_operations wo

3752: WHERE woo.wip_entity_id = C_rec1.wip_entity_id
3753: AND woo.organization_id = l_org_id
3754: AND woo.wip_entity_id <> l_rep_wip_entity_id
3755: AND not exists (select 'obsolete operation'
3756: from wip_operations wo
3757: where wo.wip_entity_id = woo.wip_entity_id
3758: and wo.organization_id = woo.organization_id
3759: and wo.operation_seq_num = woo.operation_seq_num
3760: and wo.disable_date <= l_transaction_date )

Line 3781: wip_operations WO

3777: NVL(WOR.APPLIED_RESOURCE_VALUE,0), 0))
3778: FROM wip_operation_resources WOR,
3779: cst_resource_overheads CRO,
3780: cst_department_overheads CDO,
3781: wip_operations WO
3782: WHERE
3783: WOR.wip_entity_id = C_rec1.wip_entity_id
3784: AND WOR.organization_id = l_org_id
3785: AND WOR.operation_seq_num = WOO.operation_seq_num

Line 3828: from wip_operations wo

3824: * l_resulting_scale_factor +
3825: DECODE(sign(nvl(wor.relieved_res_value, 0)), 1, nvl(wor.relieved_res_value, 0), 0)
3826: WHERE wor.wip_entity_id = l_rep_wip_entity_id
3827: AND not exists (select 'obsolete operation'
3828: from wip_operations wo
3829: where wo.wip_entity_id = wor.wip_entity_id
3830: and wo.organization_id = wor.organization_id
3831: and wo.operation_seq_num = wor.operation_seq_num
3832: and wo.disable_date <= l_transaction_date )

Line 3844: from wip_operations wo

3840: * l_resulting_scale_factor +
3841: DECODE(sign(NVL(WRO.COSTED_QUANTITY_RELIEVED, 0)), 1, NVL(WRO.COSTED_QUANTITY_RELIEVED, 0), 0)
3842: WHERE wro.wip_entity_id = l_rep_wip_entity_id
3843: AND not exists (select 'obsolete operation'
3844: from wip_operations wo
3845: where wo.wip_entity_id = wro.wip_entity_id
3846: and wo.organization_id = wro.organization_id
3847: and wo.operation_seq_num = wro.operation_seq_num
3848: and wo.disable_date <= l_transaction_date )

Line 3863: from wip_operations wo

3859: + DECODE(sign(nvl(relieved_ovhd_value, 0)), 1, nvl(relieved_ovhd_value, 0), 0)
3860: WHERE woo.wip_entity_id = l_rep_wip_entity_id
3861: AND woo.organization_id = l_org_id
3862: AND not exists (select 'obsolete operation'
3863: from wip_operations wo
3864: where wo.wip_entity_id = woo.wip_entity_id
3865: and wo.organization_id = woo.organization_id
3866: and wo.operation_seq_num = woo.operation_seq_num
3867: and wo.disable_date <= l_transaction_date )

Line 3886: wip_operations WO

3882: NVL(WOR.APPLIED_RESOURCE_VALUE,0), 0))
3883: FROM wip_operation_resources WOR,
3884: cst_resource_overheads CRO,
3885: cst_department_overheads CDO,
3886: wip_operations WO
3887: WHERE
3888: WOR.wip_entity_id = l_rep_wip_entity_id
3889: AND WOR.organization_id = l_org_id
3890: AND WOR.operation_seq_num = WOO.operation_seq_num

Line 3950: from wip_operations wo

3946: WHERE wip_entity_id = S_rec.wip_entity_id
3947: AND nvl(applied_resource_units, 0) >= nvl(relieved_res_units, 0)
3948: AND nvl(applied_resource_value, 0) >= nvl(relieved_res_value, 0)
3949: AND not exists (select 'obsolete operation'
3950: from wip_operations wo
3951: where wo.wip_entity_id = wor.wip_entity_id
3952: and wo.organization_id = wor.organization_id
3953: and wo.operation_seq_num = wor.operation_seq_num
3954: and wo.disable_date <= l_transaction_date );

Line 3963: from wip_operations wo

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'
3963: from wip_operations wo
3964: where wo.wip_entity_id = wro.wip_entity_id
3965: and wo.organization_id = wro.organization_id
3966: and wo.operation_seq_num = wro.operation_seq_num
3967: and wo.disable_date <= l_transaction_date );

Line 3978: from wip_operations wo

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
3977: AND not exists (select 'obsolete operation'
3978: from wip_operations wo
3979: where wo.wip_entity_id = woo.wip_entity_id
3980: and wo.organization_id = woo.organization_id
3981: and wo.operation_seq_num = woo.operation_seq_num
3982: and wo.disable_date <= l_transaction_date )