APPS.WIP_WS_SHORTAGE dependencies on WIP_OPERATIONS

Line 710: l_sql := l_sql || 'wip_operations wo ';

706: l_sql := l_sql || 'wo.scheduled_quantity, ';
707: l_sql := l_sql || 'wo.scheduled_quantity-wo.cumulative_scrap_quantity as start_qty, ';
708: l_sql := l_sql || 'wo.scheduled_quantity-wo.cumulative_scrap_quantity as open_qty ';
709: l_sql := l_sql || 'FROM wip_discrete_jobs wdj, ';
710: l_sql := l_sql || 'wip_operations wo ';
711: l_sql := l_sql || 'WHERE wdj.organization_id = :org_id ';
712: l_sql := l_sql || 'AND wdj.scheduled_start_date < :shift_end_time ';
713: l_sql := l_sql || 'AND wo.organization_id = wdj.organization_id ';
714: l_sql := l_sql || 'AND wo.wip_entity_id = wdj.wip_entity_id ';

Line 1131: wip_operations wo,

1127: wor.applied_resource_units ,
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