APPS.WSMPLBMI dependencies on BOM_DEPARTMENTS

Line 1579: FROM BOM_DEPARTMENTS bd

1575: SET (FM_DEPARTMENT_ID,
1576: FM_DEPARTMENT_CODE) =
1577: (SELECT bd.department_id,
1578: bd.department_code
1579: FROM BOM_DEPARTMENTS bd
1580: WHERE bd.department_id = l_wo_dept_id)
1581: WHERE WLMTI.header_id = p_header_id;
1582:
1583: IF (SQL%ROWCOUNT = 0) OR (SQL%NOTFOUND) THEN

Line 1813: FROM BOM_DEPARTMENTS bd

1809: SET ( TO_DEPARTMENT_ID, -- Fix bug #1501376
1810: TO_DEPARTMENT_CODE )=
1811: (SELECT bd.department_id, -- Fix bug #1501376
1812: bd.department_code
1813: FROM BOM_DEPARTMENTS bd
1814: WHERE bd.department_id = l_dept_id) -- Fix bug #1501376
1815: WHERE WLMTI.header_id = p_header_id;
1816:
1817: IF (SQL%ROWCOUNT = 0) OR (SQL%NOTFOUND) THEN

Line 2138: FROM BOM_DEPARTMENTS bd

2134: SET ( TO_DEPARTMENT_ID, -- Fix bug #1501376
2135: TO_DEPARTMENT_CODE )=
2136: (SELECT bd.department_id, -- Fix bug #1501376
2137: bd.department_code
2138: FROM BOM_DEPARTMENTS bd
2139: WHERE bd.department_id = l_jmp_dept_id)
2140: WHERE WLMTI.header_id = p_header_id;
2141:
2142: l_stmt_num := 285;

Line 2194: FROM BOM_DEPARTMENTS bd

2190: SET (FM_DEPARTMENT_ID,
2191: FM_DEPARTMENT_CODE) =
2192: (SELECT bd.department_id,
2193: bd.department_code
2194: FROM BOM_DEPARTMENTS bd
2195: WHERE bd.department_id = l_wo_dept_id)
2196: WHERE WLMTI.header_id = p_header_id;
2197: END IF;
2198:

Line 2393: FROM BOM_DEPARTMENTS bd

2389: SET ( TO_DEPARTMENT_ID, -- Fix bug #1501376
2390: TO_DEPARTMENT_CODE )=
2391: (SELECT bd.department_id, -- Fix bug #1501376
2392: bd.department_code
2393: FROM BOM_DEPARTMENTS bd
2394: WHERE bd.department_id = l_dept_id) -- Fix bug #1501376
2395: WHERE WLMTI.header_id = p_header_id
2396: RETURNING TO_DEPARTMENT_CODE
2397: INTO l_to_dept_code;

Line 2684: FROM BOM_DEPARTMENTS bd

2680: SET ( TO_DEPARTMENT_ID, -- Fix bug #1501376
2681: TO_DEPARTMENT_CODE )=
2682: (SELECT bd.department_id, -- Fix bug #1501376
2683: bd.department_code
2684: FROM BOM_DEPARTMENTS bd
2685: WHERE bd.department_id = l_jmp_dept_id)
2686: WHERE WLMTI.header_id = p_header_id
2687: RETURNING TO_DEPARTMENT_CODE
2688: INTO l_to_dept_code;

Line 3174: -- FROM BOM_DEPARTMENTS

3170: --move enh added the IF (l_scrap_acc_id IS NULL) condition
3171: -- IF (l_scrap_acc_id IS NULL) THEN
3172: -- SELECT nvl(scrap_account, -1)
3173: -- INTO l_wlmti_scrap_acct_id
3174: -- FROM BOM_DEPARTMENTS
3175: -- WHERE DEPARTMENT_ID=decode(l_scrap_at_operation_flag,
3176: -- 2, l_to_dept_id,
3177: -- l_wo_dept_id) --p_to_dept_id --Fixed bug #1928993
3178: -- WHERE DEPARTMENT_ID=l_to_dept_id --p_to_dept_id --Fixed bug #1928993

Line 3200: FROM BOM_DEPARTMENTS

3196: IF l_scrap_acc_id IS NULL THEN
3197: -- get scrap_account from BD
3198: SELECT nvl(scrap_account, -1)
3199: INTO l_wlmti_scrap_acct_id
3200: FROM BOM_DEPARTMENTS
3201: WHERE DEPARTMENT_ID=decode(l_scrap_at_operation_flag,
3202: 2, l_to_dept_id,
3203: l_wo_dept_id) --p_to_dept_id --Fixed bug #1928993
3204: AND ORGANIZATION_ID=p_org_id;

Line 3241: bom_departments bd

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;
3245: AND bd.department_id = decode(l_scrap_at_operation_flag,

Line 3329: FROM BOM_DEPARTMENTS

3325: ((nvl(l_scrap_at_operation_flag, 1)=2) AND (l_to_scrap_id IS NULL)))
3326: THEN
3327: SELECT nvl(scrap_account, -1)
3328: INTO l_wlmti_scrap_acct_id
3329: FROM BOM_DEPARTMENTS
3330: WHERE DEPARTMENT_ID=decode(l_scrap_at_operation_flag,
3331: 2, l_to_dept_id,
3332: l_wo_dept_id)
3333: AND ORGANIZATION_ID=p_org_id;

Line 3405: bom_departments bd

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,
3409: 2, l_dept_id,

Line 3433: FROM BOM_DEPARTMENTS

3429: (l_to_scrap_id IS NULL))
3430: THEN
3431: SELECT nvl(scrap_account, -1)
3432: INTO l_wlmti_scrap_acct_id
3433: FROM BOM_DEPARTMENTS
3434: WHERE DEPARTMENT_ID=decode(l_scrap_at_operation_flag,
3435: 2, l_to_dept_id,
3436: l_wo_dept_id)
3437: AND ORGANIZATION_ID=p_org_id;

Line 3496: bom_departments bd

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,
3500: 2, l_dept_id,

Line 4275: from bom_departments

4271: where wip_entity_id = l_wip_entity_id;
4272:
4273: select scrap_account, est_absorption_account
4274: into l_scrap_account, l_est_scrap_abs_account
4275: from bom_departments
4276: where department_id = l_cmp_to_dept_id;
4277:
4278: if l_scrap_account is null or l_est_scrap_abs_account is null then
4279: if l_est_scrap_acc = 1 then

Line 4968: from bom_departments

4964: --NSO Modification by abedajna addition begin
4965: --move enh? first look at copy table
4966: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4967: SET FM_DEPARTMENT_CODE = (select department_code
4968: from bom_departments
4969: where department_id = l_to_dept_id)
4970: WHERE WLMTI.header_id = p_header_id;
4971:
4972: --***VJ Added for Performance Upgrade***--

Line 4994: from bom_departments

4990:
4991: l_stmt_num := 475;
4992: UPDATE WSM_LOT_MOVE_TXN_INTERFACE WLMTI
4993: SET TO_DEPARTMENT_CODE = (select department_code
4994: from bom_departments
4995: where department_id = l_fm_dept_id)
4996: WHERE WLMTI.header_id = p_header_id;
4997:
4998: --***VJ Added for Performance Upgrade***--