DBA Data[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on WIP_PARAMETERS

Line 623: from wip_requirement_operations wro, wip_parameters mp

619: Is
620: select nvl(wro.basis_type, 1),
621: wro.required_quantity, wro.quantity_issued, wro.quantity_per_assembly,
622: decode(mp.include_component_yield, 1, nvl(wro.component_yield_factor, 1), 1)
623: from wip_requirement_operations wro, wip_parameters mp
624: where wro.organization_id = p_org_id and
625: wro.wip_entity_id = p_wip_entity_id and
626: mp.organization_id = wro.organization_id and
627: wro.operation_seq_num = p_op_seq and

Line 738: wip_parameters mp

734: wip_operations wo,
735: wip_operation_resources wor,
736: bom_resources br,
737: bom_department_resources bdr,
738: wip_parameters mp
739: where wdj.wip_entity_id = wo.wip_entity_id and
740: wdj.organization_id = wo.organization_id and
741: mp.organization_id = wdj.organization_id and
742: wo.wip_entity_id = wor.wip_entity_id and

Line 1674: from bom_department_resources bdr, wip_parameters wp

1670:
1671: select nvl(l_units, bdr.capacity_units),
1672: decode(wp.include_resource_utilization, wip_constants.yes, nvl(bdr.utilization, 1), 1)
1673: into l_units, l_utilizaiton
1674: from bom_department_resources bdr, wip_parameters wp
1675: where bdr.department_id = p_dept_id and
1676: bdr.resource_id = p_resource_id and
1677: wp.organization_id = p_org_id;
1678: