APPS.WMS_PLAN_TASKS_PVT dependencies on STANDARD

Line 1006: 'mmtt.standard_operation_id, ';

1002:
1003: l_plans_select_str := l_plans_select_str ||
1004: 'mmtt.transaction_uom, ' ||
1005: 'mmtt.transaction_quantity, '||
1006: 'mmtt.standard_operation_id, ';
1007: IF wms_plan_tasks_pvt.g_user_task_type_visible = 'T' THEN
1008: l_plans_select_str := l_plans_select_str || ' NULL, ';
1009: END IF;
1010: l_plans_select_str := l_plans_select_str ||

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

1280: END IF;
1281:
1282: IF wms_plan_tasks_pvt.g_user_task_type_id IS NOT NULL THEN
1283: l_plans_where_str := l_plans_where_str
1284: || 'AND mmtt.standard_operation_id = :user_task_type_id ';
1285: END IF;
1286:
1287: IF wms_plan_tasks_pvt.g_from_task_quantity IS NOT NULL THEN
1288: l_plans_where_str := l_plans_where_str

Line 2426: || ', bom_standard_operations bso ';

2422: END IF;
2423:
2424: IF wms_plan_tasks_pvt.g_user_task_type_visible = 'T' THEN
2425: l_wdth_from_str := l_wdth_from_str
2426: || ', bom_standard_operations bso ';
2427: END IF;
2428:
2429: IF wms_plan_tasks_pvt.g_to_organization_code_visible = 'T' THEN
2430: l_wdth_from_str := l_wdth_from_str || ', mtl_parameters mp1 ';

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

2508: END IF;
2509:
2510: IF wms_plan_tasks_pvt.g_user_task_type_visible = 'T' THEN
2511: l_wdth_where_str := l_wdth_where_str
2512: || 'AND wdth.user_task_type = bso.standard_operation_id(+) '
2513: || 'AND wdth.organization_id = bso.organization_id(+) ';
2514: END IF;
2515:
2516: l_wdth_where_str := l_wdth_where_str

Line 3791: || ', bom_standard_operations bso ';

3787: END IF;
3788:
3789: IF wms_plan_tasks_pvt.g_user_task_type_visible = 'T' THEN
3790: l_wdth_from_str := l_wdth_from_str
3791: || ', bom_standard_operations bso ';
3792: END IF;
3793:
3794: IF wms_plan_tasks_pvt.g_to_organization_code_visible = 'T' THEN
3795: l_wdth_from_str := l_wdth_from_str || ', mtl_parameters mp1 ';

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

3867: END IF;
3868:
3869: IF wms_plan_tasks_pvt.g_user_task_type_visible = 'T' THEN
3870: l_wdth_where_str := l_wdth_where_str
3871: || 'AND wdth.user_task_type = bso.standard_operation_id(+) '
3872: || 'AND wdth.organization_id = bso.organization_id(+) ';
3873: END IF;
3874:
3875: l_wdth_where_str := l_wdth_where_str