APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_DEPARTMENTS

Line 1917: from bom_departments

1913: if (v_wljdi_department_code(l_d) IS NOT NULL) then
1914: begin
1915: select unique(department_id)
1916: into l_dept_id
1917: from bom_departments
1918: where department_code = v_wljdi_department_code(l_d)
1919: and department_id = nvl(v_wljdi_department_id(l_d),department_id)
1920: and organization_id = p_org_id;
1921: exception

Line 2253: from bom_departments

2249: if (v_wljdi_department_code(l_d) IS NOT NULL) then
2250: begin
2251: select unique(department_id)
2252: into v_wljdi_department_id(l_d)
2253: from bom_departments
2254: where department_code = v_wljdi_department_code(l_d)
2255: and department_id = nvl(v_wljdi_department_id(l_d),department_id)
2256: and organization_id = p_org_id;
2257: exception

Line 2265: from bom_departments

2261: else
2262: begin
2263: select 1
2264: into l_temp
2265: from bom_departments
2266: where department_id = v_wljdi_department_id(l_d)
2267: and organization_id = p_org_id;
2268: exception
2269: when others then

Line 11064: from bom_departments bd,

11060: wo.department_id
11061: into l_scrap_account_10,
11062: l_est_scrap_abs_account_10,
11063: l_department_id
11064: from bom_departments bd,
11065: wip_operations wo
11066: where wo.wip_entity_id = v_wlji_wip_entity_id(v_idx)
11067: and wo.operation_seq_num = l_min_op_seq_num
11068: and bd.department_id = wo.department_id;

Line 15726: from bom_departments

15722: if (v_wljdi_substitution_type(l_d) = WSM_SUB_ADD) then
15723:
15724: select scrap_account,est_absorption_account,department_code
15725: into l_scrap_account,l_est_absorption_account,l_department_code
15726: from bom_departments
15727: where department_id = v_wljdi_department_id(l_d)
15728: and organization_id = p_org_id;
15729:
15730: select decode(sign(min(operation_sequence_id)),-1,min(operation_sequence_id)-1,-2),