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 1154: l_select_generic || 'mmtt.standard_operation_id, ';

1150: --transaction_uom
1151: l_select_generic := l_select_generic || 'mmtt.transaction_quantity, ';
1152: --transaction_quantity
1153: l_select_generic :=
1154: l_select_generic || 'mmtt.standard_operation_id, ';
1155: --user_task_type_id
1156:
1157: IF g_user_task_type_visible = 'T'
1158: THEN

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

2841: IF g_user_task_type_visible = 'T'
2842: THEN
2843: l_where_generic :=
2844: l_where_generic
2845: || 'AND mmtt.standard_operation_id = bso.standard_operation_id(+) ';
2846: l_where_generic :=
2847: l_where_generic
2848: || 'AND mmtt.organization_id = bso.organization_id(+) ';
2849: END IF;

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

2922: IF p_user_task_type_id IS NOT NULL
2923: THEN
2924: l_where_generic :=
2925: l_where_generic
2926: || 'AND nvl(mmtt.standard_operation_id,:user_task_type_id) = :user_task_type_id '; /* Bug 5446146 */
2927: END IF;
2928:
2929: IF p_from_task_quantity IS NOT NULL
2930: THEN

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

3211: IF g_user_task_type_visible = 'T'
3212: THEN
3213: l_where_generic :=
3214: l_where_generic
3215: || 'AND wdth.user_task_type = bso.standard_operation_id(+) ';
3216: l_where_generic :=
3217: l_where_generic
3218: || 'AND wdth.organization_id = bso.organization_id(+) ';
3219: END IF;

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

3527: IF g_user_task_type_visible = 'T'
3528: THEN
3529: l_where_generic :=
3530: l_where_generic
3531: || 'AND wdth.user_task_type = bso.standard_operation_id(+) ';
3532: l_where_generic :=
3533: l_where_generic
3534: || 'AND wdth.organization_id = bso.organization_id(+) ';
3535: END IF;

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

3617: IF g_operation_plan_visible = 'T' THEN
3618: l_where_generic := l_where_generic || 'AND wdth.operation_plan_id = wop.operation_plan_id(+) ';
3619: END IF;
3620: IF g_user_task_type_visible = 'T' THEN
3621: l_where_generic := l_where_generic || 'AND wdth.user_task_type = bso.standard_operation_id(+) ';
3622: l_where_generic := l_where_generic || 'AND wdth.organization_id = bso.organization_id(+) ';
3623: END IF;
3624: IF p_organization_id IS NOT NULL THEN
3625: l_where_generic := l_where_generic || 'AND wdth.organization_id = :org_id ';

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

3917: l_where_generic := l_where_generic || 'AND wdt.equipment_instance = :machine_instance ';
3918: END IF;
3919:
3920: IF p_user_task_type_id IS NOT NULL THEN
3921: l_where_generic := l_where_generic || 'AND mmtt.standard_operation_id = :user_task_type_id ';
3922: END IF;
3923: /* End of Bug 5446146 */
3924:
3925: -- Concatenate the different sections of the query

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

8215: l_select_cc || 'mtst.transaction_source_type_name, ';
8216:
8217: END IF;
8218:
8219: l_select_cc := l_select_cc || 'mcce.standard_operation_id, ';
8220: --user_task_type_id
8221:
8222: IF g_user_task_type_visible = 'T'
8223: 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 8627: || 'AND mcce.standard_operation_id = bso.standard_operation_id(+) ';

8623: IF g_user_task_type_visible = 'T'
8624: THEN
8625: l_where_cc :=
8626: l_where_cc
8627: || 'AND mcce.standard_operation_id = bso.standard_operation_id(+) ';
8628: END IF;
8629:
8630: IF p_organization_id IS NOT NULL
8631: THEN

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

8711: IF p_user_task_type_id IS NOT NULL
8712: THEN
8713: l_where_cc :=
8714: l_where_cc
8715: || 'AND mcce.standard_operation_id = :user_task_type_id ';
8716: END IF;
8717:
8718: IF p_from_task_priority IS NOT NULL
8719: THEN

Line 11170: WHERE wwtt.user_task_type_id = bsor.standard_operation_id

11166: AND NOT EXISTS (
11167: SELECT 1
11168: FROM bom_std_op_resources bsor,
11169: bom_resource_employees bre
11170: WHERE wwtt.user_task_type_id = bsor.standard_operation_id
11171: AND bsor.resource_id = bre.resource_id
11172: AND bre.person_id = p_employee_id);
11173:
11174: --j Develop

Line 11219: WHERE wwtt.user_task_type_id = bsor.standard_operation_id

11215: UPDATE wms_waveplan_tasks_temp wwtt
11216: SET person_resource_id =
11217: (SELECT bre.resource_id
11218: FROM bom_std_op_resources bsor, bom_resource_employees bre
11219: WHERE wwtt.user_task_type_id = bsor.standard_operation_id
11220: AND bsor.resource_id = bre.resource_id
11221: AND bre.person_id = wwtt.person_id
11222: AND ROWNUM < 2)
11223: WHERE RESULT = 'X';

Line 11811: standard_operation_id = l_user_task_type_id (i)

11807: task_priority = l_task_priority_table (i),
11808: last_update_date = SYSDATE,
11809: last_updated_by = p_user_id,
11810: last_update_login = p_login_id,
11811: standard_operation_id = l_user_task_type_id (i)
11812: WHERE transaction_temp_id = l_transaction_temp_id_table (i) -- R12: Update User Task Type Id
11813: AND l_task_type_id (i) <> 3;
11814: if l_debug = 1 then
11815: DEBUG ('No of records updated are-777 ' || SQL%ROWCOUNT);

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

11823: SET task_priority = l_task_priority_table (i),
11824: last_update_date = SYSDATE,
11825: last_updated_by = p_user_id,
11826: last_update_login = p_login_id,
11827: standard_operation_id = l_user_task_type_id (i) --R12: Update User Task Type Id
11828: WHERE cycle_count_entry_id IN (
11829: SELECT mcce.cycle_count_entry_id
11830: FROM wms_waveplan_tasks_temp wwtt, mtl_cycle_count_entries mcce, mtl_cycle_count_headers mcch
11831: WHERE wwtt.transaction_temp_id=l_transaction_temp_id_table (i)

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 12660: AND wwtt.user_task_type_id = bso.standard_operation_id(+)

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,
12663: bso.operation_code,
12664: bso.operation_description,

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;

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

13089: l_where_generic := l_where_generic || 'AND wdth.operation_plan_id = wop.operation_plan_id(+) ';
13090: END IF;
13091:
13092: IF g_user_task_type_visible = 'T' THEN
13093: l_where_generic := l_where_generic || 'AND wdth.user_task_type = bso.standard_operation_id(+) ';
13094: l_where_generic := l_where_generic || 'AND wdth.organization_id = bso.organization_id(+) ';
13095: END IF;
13096:
13097: