APPS.WIP_WS_SHORTAGE dependencies on WIP_PARAMETERS

Line 528: l_sql := l_sql || ' wip_parameters wp ';

524: l_sql := l_sql || ' wro.supply_subinventory) supply_subinventory ';
525: l_sql := l_sql || ' from wip_discrete_jobs wdj, ';
526: l_sql := l_sql || ' wip_requirement_operations wro, ';
527: l_sql := l_sql || ' mtl_system_items msi, ';
528: l_sql := l_sql || ' wip_parameters wp ';
529: l_sql := l_sql || ' where wdj.organization_id = :org_id ';
530: l_sql := l_sql || ' and wdj.start_quantity - wdj.quantity_completed - wdj.quantity_scrapped > 0 ';
531: l_sql := l_sql || ' and wdj.scheduled_start_date < :shift_end_time ';
532: l_sql := l_sql || ' and wro.organization_id = wdj.organization_id ';

Line 890: l_sql := l_sql || ' wip_parameters wp ';

886: l_sql := l_sql || ' msi.primary_uom_code, ';
887: l_sql := l_sql || ' decode(wp.include_component_yield, 1, nvl(wro.component_yield_factor, 1), 1) ';
888: l_sql := l_sql || ' from wip_requirement_operations wro, ';
889: l_sql := l_sql || ' mtl_system_items msi, ';
890: l_sql := l_sql || ' wip_parameters wp ';
891: l_sql := l_sql || ' where wro.organization_id = :l_org_id ';
892: l_sql := l_sql || ' and wro.wip_entity_id = :l_wip_ent_id ';
893: l_sql := l_sql || ' and wro.operation_seq_num = :l_operation_seq_num ';
894: --bug 6983119 - Added the condition wro.quantity_per_assembly > 0

Line 1201: wip_parameters wp,

1197: wor.basis_type,
1198: decode(wp.include_resource_efficiency, 1, nvl(bdr.efficiency, 1), 1) efficiency
1199: from wip_operation_resources wor,
1200: wip_operations wo,
1201: wip_parameters wp,
1202: bom_department_resources bdr
1203: where wor.organization_id = p_org_id
1204: and wor.wip_entity_id = p_wip_ent_id
1205: and wor.operation_seq_num = p_op_seq_num