DBA Data[Home] [Help]

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 6970: from bom_departments bd, wip_operations wo

6966: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6967:
6968: select bd.scrap_account, bd.est_absorption_account, wo.department_id
6969: into l_scrap_account10, l_est_scrap_abs_account10, l_department_id
6970: from bom_departments bd, wip_operations wo
6971: where wo.wip_entity_id = v_wlji_wip_entity_id(v_index)
6972: and wo.operation_seq_num = min_op_seq_num
6973: and bd.department_id = wo.department_id;
6974:

Line 7005: from bom_departments bd, wip_operations wo

7001: where wip_entity_id = v_wlji_wip_entity_id(v_index);
7002:
7003: select bd.scrap_account, bd.est_absorption_account, wo.department_id
7004: into l_scrap_account9999, l_est_scrap_abs_account9999, l_department_id
7005: from bom_departments bd, wip_operations wo
7006: where wo.wip_entity_id = v_wlji_wip_entity_id(v_index)
7007: and wo.operation_seq_num = max_op_seq_num
7008: and bd.department_id = wo.department_id;
7009: