[Home] [Help]
3236: --bug 3571019 added decode so that we get the scrap account depending on the l_scrap_at_operation_flag
3237: BEGIN
3238: SELECT bd.department_id
3239: INTO l_temp
3240: FROM gl_code_combinations gcc,
3241: bom_departments bd
3242: WHERE gcc.code_combination_id = l_wlmti_scrap_acct_id
3243: AND bd.scrap_account = l_wlmti_scrap_acct_id
3244: -- AND bd.department_id = l_dept_id;
3265: BEGIN
3266:
3267: SELECT code_combination_id
3268: INTO l_temp
3269: FROM gl_code_combinations gl
3270: WHERE gl.code_combination_id = l_wlmti_scrap_acct_id
3271: and gl.enabled_flag = 'Y'
3272: and gl.summary_flag = 'N'
3273: and NVL(gl.start_date_active, sysdate) <= sysdate
3368:
3369: BEGIN
3370: SELECT gcc.code_combination_id
3371: INTO l_temp
3372: FROM gl_code_combinations gcc
3373: WHERE gcc.code_combination_id = l_wlmti_scrap_acct_id;
3374: EXCEPTION
3375: WHEN NO_DATA_FOUND THEN
3376: x_return_code := 1;
3389: --record will not be there in WCO.
3390: IF (nvl(p_to_op_seq_num, -1) <> -1) THEN --regular move or jump inside rtg
3391: SELECT gcc.code_combination_id
3392: INTO l_temp
3393: FROM gl_code_combinations gcc,
3394: WSM_COPY_OPERATIONS WCO
3395: WHERE gcc.code_combination_id = l_wlmti_scrap_acct_id
3396: AND WCO.scrap_account = gcc.code_combination_id
3397: AND WCO.wip_entity_id = l_wip_entity_id
3400: l_wo_rtg_op_seq_num);
3401: ELSE --jump outside rtg
3402: SELECT gcc.code_combination_id
3403: INTO l_temp
3404: FROM gl_code_combinations gcc,
3405: bom_departments bd
3406: WHERE gcc.code_combination_id = l_wlmti_scrap_acct_id
3407: AND bd.scrap_account = gcc.code_combination_id
3408: AND bd.department_id = decode(l_scrap_at_operation_flag,
3472:
3473: BEGIN
3474: SELECT gcc.code_combination_id
3475: INTO l_temp
3476: FROM gl_code_combinations gcc
3477: WHERE gcc.code_combination_id = l_wlmti_scrap_acct_id;
3478: EXCEPTION
3479: WHEN NO_DATA_FOUND THEN
3480: x_return_code := 1;
3491:
3492: BEGIN
3493: SELECT gcc.code_combination_id
3494: INTO l_temp
3495: FROM gl_code_combinations gcc,
3496: bom_departments bd
3497: WHERE gcc.code_combination_id = l_wlmti_scrap_acct_id
3498: AND bd.scrap_account = gcc.code_combination_id
3499: AND bd.department_id = decode(l_scrap_at_operation_flag,
3519: BEGIN
3520:
3521: SELECT code_combination_id
3522: INTO l_temp
3523: FROM gl_code_combinations gl
3524: WHERE gl.code_combination_id = l_wlmti_scrap_acct_id
3525: and gl.enabled_flag = 'Y'
3526: and gl.summary_flag = 'N'
3527: and NVL(gl.start_date_active, sysdate) <= sysdate