APPS.WIP_WS_SHORTAGE dependencies on WIP_PARAMETERS

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

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

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

845: l_sql := l_sql || ' msi.primary_uom_code, ';
846: l_sql := l_sql || ' decode(wp.include_component_yield, 1, nvl(wro.component_yield_factor, 1), 1) ';
847: l_sql := l_sql || ' from wip_requirement_operations wro, ';
848: l_sql := l_sql || ' mtl_system_items msi, ';
849: l_sql := l_sql || ' wip_parameters wp ';
850: l_sql := l_sql || ' where wro.organization_id = :l_org_id ';
851: l_sql := l_sql || ' and wro.wip_entity_id = :l_wip_ent_id ';
852: l_sql := l_sql || ' and wro.operation_seq_num = :l_operation_seq_num ';
853: --bug 6983119 - Added the condition wro.quantity_per_assembly > 0

Line 1132: wip_parameters wp,

1128: wor.basis_type,
1129: decode(wp.include_resource_efficiency, 1, nvl(bdr.efficiency, 1), 1) efficiency
1130: from wip_operation_resources wor,
1131: wip_operations wo,
1132: wip_parameters wp,
1133: bom_department_resources bdr
1134: where wor.organization_id = p_org_id
1135: and wor.wip_entity_id = p_wip_ent_id
1136: and wor.operation_seq_num = p_op_seq_num