APPS.WIP_WS_SHORTAGE dependencies on WIP_OPERATIONS

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

747: l_sql := l_sql || 'wo.scheduled_quantity, ';
748: l_sql := l_sql || 'wo.scheduled_quantity-wo.cumulative_scrap_quantity as start_qty, ';
749: l_sql := l_sql || 'wo.scheduled_quantity-wo.cumulative_scrap_quantity as open_qty ';
750: l_sql := l_sql || 'FROM wip_discrete_jobs wdj, ';
751: l_sql := l_sql || 'wip_operations wo ';
752: l_sql := l_sql || 'WHERE wdj.organization_id = :org_id ';
753: l_sql := l_sql || 'AND wdj.scheduled_start_date < :shift_end_time ';
754: l_sql := l_sql || 'AND wo.organization_id = wdj.organization_id ';
755: l_sql := l_sql || 'AND wo.wip_entity_id = wdj.wip_entity_id ';

Line 1200: wip_operations wo,

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