APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 3955: bom_department_resources bdr

3951: wo.last_unit_completion_date
3952: into l_op_sdate,
3953: l_op_edate
3954: from wip_operations wo,
3955: bom_department_resources bdr
3956: where wo.wip_entity_id = p_wip_entity_id
3957: and wo.operation_seq_num = l_job_op_seq_num
3958: and wo.organization_id = p_org_id
3959: and bdr.resource_id = l_resource_id

Line 4068: bom_department_resources bdr

4064: reco_completion_date
4065: into l_op_sdate,
4066: l_op_edate
4067: from wsm_copy_operations wco,
4068: bom_department_resources bdr
4069: where wip_entity_id = p_wip_entity_id
4070: and operation_seq_num = l_rtg_op_seq_num
4071: and organization_id = p_org_id
4072: and bdr.resource_id = l_resource_id

Line 13778: from bom_resources br,bom_department_resources bdr, wip_operations wo

13774: begin
13775:
13776: select nvl(p_new_res_tbl(l_index).dept_id,wo.department_id)
13777: into p_new_res_tbl(l_index).dept_id
13778: from bom_resources br,bom_department_resources bdr, wip_operations wo
13779: where br.resource_id = p_new_res_tbl(l_index).resource_id
13780: and br.resource_code = p_new_res_tbl(l_index).resource_code
13781: and (br.disable_date > sysdate or br.disable_date is null)
13782: and br.organization_id = p_org_id

Line 13845: from bom_resources br,bom_department_resources bdr, wsm_copy_operations wco

13841: begin
13842:
13843: select nvl(p_new_res_tbl(l_index).dept_id,wco.department_id)
13844: into p_new_res_tbl(l_index).dept_id
13845: from bom_resources br,bom_department_resources bdr, wsm_copy_operations wco
13846: where br.resource_id = p_new_res_tbl(l_index).resource_id
13847: and br.resource_code = p_new_res_tbl(l_index).resource_code
13848: and (br.disable_date > sysdate or br.disable_date is null)
13849: and br.organization_id = p_org_id