DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on BOM_STANDARD_OPERATIONS

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

2019: END IF;
2020:
2021: IF g_user_task_type_visible = 'T'
2022: THEN
2023: l_from_generic := l_from_generic || ', bom_standard_operations bso ';
2024: END IF;
2025:
2026: IF g_to_organization_code_visible = 'T'
2027: THEN

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

7564: END IF;
7565:
7566: IF g_user_task_type_visible = 'T'
7567: THEN
7568: l_from_cc := l_from_cc || ', bom_standard_operations bso ';
7569: END IF;
7570:
7571: IF g_txn_source_type_visible = 'T'
7572: THEN

Line 11515: FROM wms_waveplan_tasks_temp wwtt, bom_standard_operations bso

11511: ROUND (SUM (wwtt.time_estimate), 1), p_time_uom,
11512: ROUND (SUM (wwtt.display_weight), 1), p_weight_uom,
11513: ROUND (SUM (wwtt.display_volume), 1), p_volume_uom,
11514: wwtt.organization_id
11515: FROM wms_waveplan_tasks_temp wwtt, bom_standard_operations bso
11516: WHERE wwtt.RESULT IN ('X', 'Y', 'Z')
11517: AND wwtt.user_task_type_id = bso.standard_operation_id(+)
11518: AND wwtt.organization_id = bso.organization_id(+)
11519: GROUP BY wwtt.user_task_type_id,