DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on BOM_STANDARD_OPERATIONS

Line 2324: l_from_generic := l_from_generic || ', bom_standard_operations bso ';

2320: END IF;
2321:
2322: IF g_user_task_type_visible = 'T'
2323: THEN
2324: l_from_generic := l_from_generic || ', bom_standard_operations bso ';
2325: END IF;
2326:
2327: IF g_to_organization_code_visible = 'T'
2328: THEN

Line 8343: l_from_cc := l_from_cc || ', bom_standard_operations bso ';

8339: END IF;
8340:
8341: IF g_user_task_type_visible = 'T'
8342: THEN
8343: l_from_cc := l_from_cc || ', bom_standard_operations bso ';
8344: END IF;
8345:
8346: IF g_txn_source_type_visible = 'T'
8347: THEN

Line 12658: FROM wms_waveplan_tasks_temp wwtt, bom_standard_operations bso

12654: ROUND (SUM (wwtt.time_estimate), 1), p_time_uom,
12655: ROUND (SUM (wwtt.display_weight), 1), p_weight_uom,
12656: ROUND (SUM (wwtt.display_volume), 1), p_volume_uom,
12657: wwtt.organization_id
12658: FROM wms_waveplan_tasks_temp wwtt, bom_standard_operations bso
12659: WHERE wwtt.RESULT IN ('X', 'Y', 'Z')
12660: AND wwtt.user_task_type_id = bso.standard_operation_id(+)
12661: AND wwtt.organization_id = bso.organization_id(+)
12662: GROUP BY wwtt.user_task_type_id,

Line 13038: l_from_generic := l_from_generic || ', bom_standard_operations bso ';

13034: IF p_item_category_id IS NOT NULL OR p_category_set_id IS NOT NULL THEN
13035: l_from_generic := l_from_generic || ', mtl_item_categories mic ';
13036: END IF;
13037: IF g_user_task_type_visible = 'T' THEN
13038: l_from_generic := l_from_generic || ', bom_standard_operations bso ';
13039: END IF;
13040: IF g_to_organization_code_visible = 'T' THEN
13041: l_from_generic := l_from_generic || ', mtl_parameters mp1 ';
13042: END IF;