APPS.WSMPLBJI dependencies on BOM_DEPARTMENTS

Line 1727: from bom_departments

1723:
1724: l_stat_num := 30;
1725: select scrap_account, est_absorption_account
1726: into l_scrap_account, l_est_scrap_abs_account
1727: from bom_departments
1728: where department_id = l_department_id;
1729:
1730:
1731: -- abb H optional scrap accounting

Line 6964: from bom_departments bd, wip_operations wo

6960: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6961:
6962: select bd.scrap_account, bd.est_absorption_account, wo.department_id
6963: into l_scrap_account10, l_est_scrap_abs_account10, l_department_id
6964: from bom_departments bd, wip_operations wo
6965: where wo.wip_entity_id = v_wlji_wip_entity_id(v_index)
6966: and wo.operation_seq_num = min_op_seq_num
6967: and bd.department_id = wo.department_id;
6968:

Line 6999: from bom_departments bd, wip_operations wo

6995: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6996:
6997: select bd.scrap_account, bd.est_absorption_account, wo.department_id
6998: into l_scrap_account9999, l_est_scrap_abs_account9999, l_department_id
6999: from bom_departments bd, wip_operations wo
7000: where wo.wip_entity_id = v_wlji_wip_entity_id(v_index)
7001: and wo.operation_seq_num = max_op_seq_num
7002: and bd.department_id = wo.department_id;
7003: