APPS.WMS_PLAN_TASKS_PVT dependencies on STANDARD

Line 1030: 'mmtt.standard_operation_id, ';

1026:
1027: l_plans_select_str := l_plans_select_str ||
1028: 'mmtt.transaction_uom, ' ||
1029: 'mmtt.transaction_quantity, '||
1030: 'mmtt.standard_operation_id, ';
1031: IF wms_plan_tasks_pvt.g_user_task_type_visible = 'T' THEN
1032: l_plans_select_str := l_plans_select_str || ' NULL, ';
1033: END IF;
1034: l_plans_select_str := l_plans_select_str ||

Line 1309: || 'AND mmtt.standard_operation_id = :user_task_type_id ';

1305: END IF;
1306:
1307: IF wms_plan_tasks_pvt.g_user_task_type_id IS NOT NULL THEN
1308: l_plans_where_str := l_plans_where_str
1309: || 'AND mmtt.standard_operation_id = :user_task_type_id ';
1310: END IF;
1311:
1312: IF wms_plan_tasks_pvt.g_from_task_quantity IS NOT NULL THEN
1313: l_plans_where_str := l_plans_where_str

Line 2457: || ', bom_standard_operations bso ';

2453: END IF;
2454:
2455: IF wms_plan_tasks_pvt.g_user_task_type_visible = 'T' THEN
2456: l_wdth_from_str := l_wdth_from_str
2457: || ', bom_standard_operations bso ';
2458: END IF;
2459:
2460: IF wms_plan_tasks_pvt.g_to_organization_code_visible = 'T' THEN
2461: l_wdth_from_str := l_wdth_from_str || ', mtl_parameters mp1 ';

Line 2543: || 'AND wdth.user_task_type = bso.standard_operation_id(+) '

2539: END IF;
2540:
2541: IF wms_plan_tasks_pvt.g_user_task_type_visible = 'T' THEN
2542: l_wdth_where_str := l_wdth_where_str
2543: || 'AND wdth.user_task_type = bso.standard_operation_id(+) '
2544: || 'AND wdth.organization_id = bso.organization_id(+) ';
2545: END IF;
2546:
2547: l_wdth_where_str := l_wdth_where_str

Line 3901: || ', bom_standard_operations bso ';

3897: END IF;
3898:
3899: IF wms_plan_tasks_pvt.g_user_task_type_visible = 'T' THEN
3900: l_wdth_from_str := l_wdth_from_str
3901: || ', bom_standard_operations bso ';
3902: END IF;
3903:
3904: IF wms_plan_tasks_pvt.g_to_organization_code_visible = 'T' THEN
3905: l_wdth_from_str := l_wdth_from_str || ', mtl_parameters mp1 ';

Line 3981: || 'AND wdth.user_task_type = bso.standard_operation_id(+) '

3977: END IF;
3978:
3979: IF wms_plan_tasks_pvt.g_user_task_type_visible = 'T' THEN
3980: l_wdth_where_str := l_wdth_where_str
3981: || 'AND wdth.user_task_type = bso.standard_operation_id(+) '
3982: || 'AND wdth.organization_id = bso.organization_id(+) ';
3983: END IF;
3984:
3985: l_wdth_where_str := l_wdth_where_str