APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_DEPARTMENTS

Line 1922: from bom_departments

1918: if (v_wljdi_department_code(l_d) IS NOT NULL) then
1919: begin
1920: select unique(department_id)
1921: into l_dept_id
1922: from bom_departments
1923: where department_code = v_wljdi_department_code(l_d)
1924: and department_id = nvl(v_wljdi_department_id(l_d),department_id)
1925: and organization_id = p_org_id;
1926: exception

Line 2258: from bom_departments

2254: if (v_wljdi_department_code(l_d) IS NOT NULL) then
2255: begin
2256: select unique(department_id)
2257: into v_wljdi_department_id(l_d)
2258: from bom_departments
2259: where department_code = v_wljdi_department_code(l_d)
2260: and department_id = nvl(v_wljdi_department_id(l_d),department_id)
2261: and organization_id = p_org_id;
2262: exception

Line 2270: from bom_departments

2266: else
2267: begin
2268: select 1
2269: into l_temp
2270: from bom_departments
2271: where department_id = v_wljdi_department_id(l_d)
2272: and organization_id = p_org_id;
2273: exception
2274: when others then

Line 11166: from bom_departments bd,

11162: wo.department_id
11163: into l_scrap_account_10,
11164: l_est_scrap_abs_account_10,
11165: l_department_id
11166: from bom_departments bd,
11167: wip_operations wo
11168: where wo.wip_entity_id = v_wlji_wip_entity_id(v_idx)
11169: and wo.operation_seq_num = l_min_op_seq_num
11170: and bd.department_id = wo.department_id;

Line 16102: from bom_departments

16098: if (v_wljdi_substitution_type(l_d) = WSM_SUB_ADD) then
16099:
16100: select scrap_account,est_absorption_account,department_code
16101: into l_scrap_account,l_est_absorption_account,l_department_code
16102: from bom_departments
16103: where department_id = v_wljdi_department_id(l_d)
16104: and organization_id = p_org_id;
16105:
16106: select decode(sign(min(operation_sequence_id)),-1,min(operation_sequence_id)-1,-2),