APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_DEPARTMENT_RESOURCES

Line 3950: bom_department_resources bdr

3946: wo.last_unit_completion_date
3947: into l_op_sdate,
3948: l_op_edate
3949: from wip_operations wo,
3950: bom_department_resources bdr
3951: where wo.wip_entity_id = p_wip_entity_id
3952: and wo.operation_seq_num = l_job_op_seq_num
3953: and wo.organization_id = p_org_id
3954: and bdr.resource_id = l_resource_id

Line 4063: bom_department_resources bdr

4059: reco_completion_date
4060: into l_op_sdate,
4061: l_op_edate
4062: from wsm_copy_operations wco,
4063: bom_department_resources bdr
4064: where wip_entity_id = p_wip_entity_id
4065: and operation_seq_num = l_rtg_op_seq_num
4066: and organization_id = p_org_id
4067: and bdr.resource_id = l_resource_id

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

13670: begin
13671:
13672: select nvl(p_new_res_tbl(l_index).dept_id,wo.department_id)
13673: into p_new_res_tbl(l_index).dept_id
13674: from bom_resources br,bom_department_resources bdr, wip_operations wo
13675: where br.resource_id = p_new_res_tbl(l_index).resource_id
13676: and br.resource_code = p_new_res_tbl(l_index).resource_code
13677: and (br.disable_date > sysdate or br.disable_date is null)
13678: and br.organization_id = p_org_id

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

13737: begin
13738:
13739: select nvl(p_new_res_tbl(l_index).dept_id,wco.department_id)
13740: into p_new_res_tbl(l_index).dept_id
13741: from bom_resources br,bom_department_resources bdr, wsm_copy_operations wco
13742: where br.resource_id = p_new_res_tbl(l_index).resource_id
13743: and br.resource_code = p_new_res_tbl(l_index).resource_code
13744: and (br.disable_date > sysdate or br.disable_date is null)
13745: and br.organization_id = p_org_id