eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on STANDARD

Line 1047: l_select_generic || 'mmtt.standard_operation_id, ';

1043: --transaction_uom
1044: l_select_generic := l_select_generic || 'mmtt.transaction_quantity, ';
1045: --transaction_quantity
1046: l_select_generic :=
1047: l_select_generic || 'mmtt.standard_operation_id, ';
1048: --user_task_type_id
1049:
1050: IF g_user_task_type_visible = 'T'
1051: THEN

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 2542: || 'AND mmtt.standard_operation_id = bso.standard_operation_id(+) ';

2538: IF g_user_task_type_visible = 'T'
2539: THEN
2540: l_where_generic :=
2541: l_where_generic
2542: || 'AND mmtt.standard_operation_id = bso.standard_operation_id(+) ';
2543: l_where_generic :=
2544: l_where_generic
2545: || 'AND mmtt.organization_id = bso.organization_id(+) ';
2546: END IF;

Line 2623: || 'AND nvl(mmtt.standard_operation_id,:user_task_type_id) = :user_task_type_id '; /* Bug 5446146 */

2619: IF p_user_task_type_id IS NOT NULL
2620: THEN
2621: l_where_generic :=
2622: l_where_generic
2623: || 'AND nvl(mmtt.standard_operation_id,:user_task_type_id) = :user_task_type_id '; /* Bug 5446146 */
2624: END IF;
2625:
2626: IF p_from_task_quantity IS NOT NULL
2627: THEN

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

2877: IF g_user_task_type_visible = 'T'
2878: THEN
2879: l_where_generic :=
2880: l_where_generic
2881: || 'AND wdth.user_task_type = bso.standard_operation_id(+) ';
2882: l_where_generic :=
2883: l_where_generic
2884: || 'AND wdth.organization_id = bso.organization_id(+) ';
2885: END IF;

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

3179: IF g_user_task_type_visible = 'T'
3180: THEN
3181: l_where_generic :=
3182: l_where_generic
3183: || 'AND wdth.user_task_type = bso.standard_operation_id(+) ';
3184: l_where_generic :=
3185: l_where_generic
3186: || 'AND wdth.organization_id = bso.organization_id(+) ';
3187: END IF;

Line 3396: l_where_generic := l_where_generic || 'AND mmtt.standard_operation_id = :user_task_type_id ';

3392: l_where_generic := l_where_generic || 'AND wdt.equipment_instance = :machine_instance ';
3393: END IF;
3394:
3395: IF p_user_task_type_id IS NOT NULL THEN
3396: l_where_generic := l_where_generic || 'AND mmtt.standard_operation_id = :user_task_type_id ';
3397: END IF;
3398: /* End of Bug 5446146 */
3399:
3400: -- Concatenate the different sections of the query

Line 7421: l_select_cc := l_select_cc || 'mcce.standard_operation_id, ';

7417: l_group_by_cc :=
7418: l_group_by_cc || 'mtst.transaction_source_type_name, '; --transaction_source_type
7419: END IF;
7420:
7421: l_select_cc := l_select_cc || 'mcce.standard_operation_id, ';
7422: l_group_by_cc := l_group_by_cc || 'mcce.standard_operation_id, ';
7423: --user_task_type_id
7424:
7425: IF g_user_task_type_visible = 'T'

Line 7422: l_group_by_cc := l_group_by_cc || 'mcce.standard_operation_id, ';

7418: l_group_by_cc || 'mtst.transaction_source_type_name, '; --transaction_source_type
7419: END IF;
7420:
7421: l_select_cc := l_select_cc || 'mcce.standard_operation_id, ';
7422: l_group_by_cc := l_group_by_cc || 'mcce.standard_operation_id, ';
7423: --user_task_type_id
7424:
7425: IF g_user_task_type_visible = 'T'
7426: 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 7840: || 'AND mcce.standard_operation_id = bso.standard_operation_id(+) ';

7836: IF g_user_task_type_visible = 'T'
7837: THEN
7838: l_where_cc :=
7839: l_where_cc
7840: || 'AND mcce.standard_operation_id = bso.standard_operation_id(+) ';
7841: END IF;
7842:
7843: IF p_organization_id IS NOT NULL
7844: THEN

Line 7928: || 'AND mcce.standard_operation_id = :user_task_type_id ';

7924: IF p_user_task_type_id IS NOT NULL
7925: THEN
7926: l_where_cc :=
7927: l_where_cc
7928: || 'AND mcce.standard_operation_id = :user_task_type_id ';
7929: END IF;
7930:
7931: IF p_from_task_priority IS NOT NULL
7932: THEN

Line 10165: WHERE wwtt.user_task_type_id = bsor.standard_operation_id

10161: AND NOT EXISTS (
10162: SELECT 1
10163: FROM bom_std_op_resources bsor,
10164: bom_resource_employees bre
10165: WHERE wwtt.user_task_type_id = bsor.standard_operation_id
10166: AND bsor.resource_id = bre.resource_id
10167: AND bre.person_id = p_employee_id);
10168:
10169: --j Develop

Line 10214: WHERE wwtt.user_task_type_id = bsor.standard_operation_id

10210: UPDATE wms_waveplan_tasks_temp wwtt
10211: SET person_resource_id =
10212: (SELECT bre.resource_id
10213: FROM bom_std_op_resources bsor, bom_resource_employees bre
10214: WHERE wwtt.user_task_type_id = bsor.standard_operation_id
10215: AND bsor.resource_id = bre.resource_id
10216: AND bre.person_id = wwtt.person_id
10217: AND ROWNUM < 2)
10218: WHERE RESULT = 'X';

Line 10806: standard_operation_id = l_user_task_type_id (i)

10802: task_priority = l_task_priority_table (i),
10803: last_update_date = SYSDATE,
10804: last_updated_by = p_user_id,
10805: last_update_login = p_login_id,
10806: standard_operation_id = l_user_task_type_id (i)
10807: WHERE transaction_temp_id = l_transaction_temp_id_table (i) -- R12: Update User Task Type Id
10808: AND l_task_type_id (i) <> 3;
10809: if l_debug = 1 then
10810: DEBUG ('No of records updated are-777 ' || SQL%ROWCOUNT);

Line 10821: standard_operation_id = l_user_task_type_id (i) -- R12: Update User Task Type Id

10817: SET task_priority = l_task_priority_table (i),
10818: last_update_date = SYSDATE,
10819: last_updated_by = p_user_id,
10820: last_update_login = p_login_id,
10821: standard_operation_id = l_user_task_type_id (i) -- R12: Update User Task Type Id
10822: WHERE cycle_count_entry_id = l_transaction_temp_id_table (i)
10823: AND l_task_type_id (i) = 3;
10824: if l_debug = 1 then
10825: DEBUG ('No of records updated are-666 ' || SQL%ROWCOUNT);

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,

Line 11517: AND wwtt.user_task_type_id = bso.standard_operation_id(+)

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,
11520: bso.operation_code,
11521: bso.operation_description,