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_TASK_DISPATCH_GEN dependencies on STANDARD

Line 176: , NVL(standard_operation_id, 2)

172: )
173: (SELECT l_task_id
174: , transaction_temp_id
175: , organization_id
176: , NVL(standard_operation_id, 2)
177: , l_person_id
178: , SYSDATE
179: , SYSDATE
180: , l_eqp_id

Line 706: , t.standard_operation_id

702: IF (task_rec.task_type <> 3) THEN
703: -- Picking, Putaway, or Replenishment task
704: SELECT bremp.resource_id role_id
705: , t.wms_task_type
706: , t.standard_operation_id
707: , t.operation_plan_id
708: , t.move_order_line_id
709: INTO l_per_res_id
710: , l_wms_task_type

Line 716: AND t.standard_operation_id = bsor.standard_operation_id

712: , l_operation_plan_id
713: , l_move_order_line_id
714: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
715: WHERE t.transaction_temp_id = task_rec.task_id
716: AND t.standard_operation_id = bsor.standard_operation_id
717: AND bsor.resource_id = bremp.resource_id
718: AND bremp.resource_type = 2
719: AND ROWNUM < 2;
720: ELSE

Line 724: , mcce.standard_operation_id

720: ELSE
721: -- Cycle counting task
722: SELECT bremp.resource_id role_id
723: , 3
724: , mcce.standard_operation_id
725: INTO l_per_res_id
726: , l_wms_task_type
727: , l_std_op_id
728: --Bug 3808770- Added the table mtl_cycle_count_headers in the FROM clause

Line 731: AND mcce.standard_operation_id = bsor.standard_operation_id

727: , l_std_op_id
728: --Bug 3808770- Added the table mtl_cycle_count_headers in the FROM clause
729: FROM mtl_cycle_count_entries mcce, bom_std_op_resources bsor, bom_resources bremp,mtl_cycle_count_headers mcch
730: WHERE mcce.cycle_count_entry_id = task_rec.task_id
731: AND mcce.standard_operation_id = bsor.standard_operation_id
732: AND bsor.resource_id = bremp.resource_id
733: AND bremp.resource_type = 2
734: AND ROWNUM < 2
735: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 757: --and t.standard_operation_id = bsor.standard_operation_id

753: --from mtl_material_transactions_temp t,
754: --bom_std_op_resources bsor,
755: --bom_resources breqp
756: --where t.transaction_temp_id = task_rec.task_id
757: --and t.standard_operation_id = bsor.standard_operation_id
758: --and bsor.resource_id = breqp.resource_id
759: --and breqp.resource_type = 1
760: --and rownum<2;
761:

Line 1272: , t.standard_operation_id

1268: IF (task_rec.task_type <> 3) THEN
1269: -- Picking, Putaway, or Replenishment task
1270: SELECT bremp.resource_id role_id
1271: , t.wms_task_type
1272: , t.standard_operation_id
1273: , t.operation_plan_id
1274: , t.move_order_line_id
1275: INTO l_per_res_id
1276: , l_wms_task_type

Line 1282: AND t.standard_operation_id = bsor.standard_operation_id

1278: , l_operation_plan_id
1279: , l_move_order_line_id
1280: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
1281: WHERE t.transaction_temp_id = task_rec.task_id
1282: AND t.standard_operation_id = bsor.standard_operation_id
1283: AND bsor.resource_id = bremp.resource_id
1284: AND bremp.resource_type = 2
1285: AND ROWNUM < 2;
1286: /*ELSE

Line 1291: mcce.standard_operation_id

1287: -- Cycle counting task
1288: SELECT
1289: bremp.resource_id role_id,
1290: 3,
1291: mcce.standard_operation_id
1292: INTO
1293: l_per_res_id,
1294: l_wms_task_type,
1295: l_std_op_id

Line 1301: and mcce.standard_operation_id = bsor.standard_operation_id

1297: mtl_cycle_count_entries mcce,
1298: bom_std_op_resources bsor,
1299: bom_resources bremp
1300: where mcce.cycle_count_entry_id = task_rec.task_id
1301: and mcce.standard_operation_id = bsor.standard_operation_id
1302: and bsor.resource_id = bremp.resource_id
1303: and bremp.resource_type = 2
1304: and rownum<2;
1305: */

Line 7203: , standard_operation_id

7199: , lpn_id
7200: , transfer_lpn_id
7201: , content_lpn_id
7202: , cartonization_id
7203: , standard_operation_id
7204: , wms_task_type
7205: , task_priority
7206: , container_item_id
7207: , operation_plan_id

Line 7399: , standard_operation_id

7395: , l_temp_lpn_id
7396: , l_transfer_lpn_id
7397: , l_content_lpn_id
7398: , cartonization_id
7399: , standard_operation_id
7400: , wms_task_type
7401: , task_priority
7402: , container_item_id
7403: , operation_plan_id

Line 8066: -- Standard call to check for call compatibility

8062: mydebug('validate_pick_to_lpn: Start Validate_pick_to_lpn.');
8063: END IF;
8064:
8065: --
8066: -- Standard call to check for call compatibility
8067: --
8068: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
8069: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
8070: fnd_msg_pub.ADD;

Line 9607: , standard_operation_id

9603: , lpn_id
9604: , transfer_lpn_id
9605: , content_lpn_id
9606: , cartonization_id
9607: , standard_operation_id
9608: , wms_task_type
9609: , task_priority
9610: , container_item_id
9611: , operation_plan_id

Line 9803: , standard_operation_id

9799: , NULL -- lpn_id is null for loose
9800: , l_to_lpn_id -- transfer_lpn_id is toLPN for loose
9801: , NULL -- content_lpn_id is NULL for loose
9802: , cartonization_id
9803: , standard_operation_id
9804: , wms_task_type
9805: , task_priority
9806: , container_item_id
9807: , operation_plan_id

Line 10852: 'Standard',

10848: 'SHIPMENT_PRIORITY',
10849: DECODE(WDD.SHIPMENT_PRIORITY_CODE,
10850: 'High',
10851: 20,
10852: 'Standard',
10853: 10,
10854: NULL),
10855: 'INVOICE_VALUE',
10856: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

Line 10890: 'Standard',

10886: 'SHIPMENT_PRIORITY',
10887: DECODE(WDD.SHIPMENT_PRIORITY_CODE,
10888: 'High',
10889: 20,
10890: 'Standard',
10891: 10,
10892: NULL),
10893: 'INVOICE_VALUE',
10894: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

Line 10928: 'Standard',

10924: 'SHIPMENT_PRIORITY',
10925: DECODE(WDD.SHIPMENT_PRIORITY_CODE,
10926: 'High',
10927: 20,
10928: 'Standard',
10929: 10,
10930: NULL),
10931: 'INVOICE_VALUE',
10932: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

Line 10966: 'Standard',

10962: 'SHIPMENT_PRIORITY',
10963: DECODE(WDD.SHIPMENT_PRIORITY_CODE,
10964: 'High',
10965: 20,
10966: 'Standard',
10967: 10,
10968: NULL),
10969: 'INVOICE_VALUE',
10970: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

Line 11004: 'Standard',

11000: 'SHIPMENT_PRIORITY',
11001: DECODE(WDD.SHIPMENT_PRIORITY_CODE,
11002: 'High',
11003: 20,
11004: 'Standard',
11005: 10,
11006: null),
11007: 'INVOICE_VALUE',
11008: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

Line 12840: , t.standard_operation_id

12836: END IF;
12837:
12838: SELECT bremp.resource_id role_id
12839: , t.wms_task_type
12840: , t.standard_operation_id
12841: , t.operation_plan_id
12842: , t.move_order_line_id
12843: INTO l_per_res_id
12844: , l_wms_task_type

Line 12850: AND t.standard_operation_id = bsor.standard_operation_id

12846: , l_operation_plan_id
12847: , l_move_order_line_id
12848: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
12849: WHERE t.transaction_temp_id = task_rec.task_id
12850: AND t.standard_operation_id = bsor.standard_operation_id
12851: AND bsor.resource_id = bremp.resource_id
12852: AND bremp.resource_type = 2
12853: AND ROWNUM < 2;
12854:

Line 12874: and t.standard_operation_id = bsor.standard_operation_id

12870: from mtl_material_transactions_temp t,
12871: bom_std_op_resources bsor,
12872: bom_resources breqp
12873: where t.transaction_temp_id = task_rec.task_id
12874: and t.standard_operation_id = bsor.standard_operation_id
12875: and bsor.resource_id = breqp.resource_id
12876: and breqp.resource_type = 1
12877: and rownum<2;
12878: */

Line 13185: , t.standard_operation_id

13181:
13182: BEGIN
13183: SELECT bremp.resource_id role_id
13184: , t.wms_task_type
13185: , t.standard_operation_id
13186: , t.operation_plan_id
13187: , t.move_order_line_id
13188: , t.inventory_item_id --Bug#6009436
13189: INTO l_per_res_id

Line 13197: AND t.standard_operation_id = bsor.standard_operation_id

13193: , l_move_order_line_id
13194: , l_item_id --Bug6009436
13195: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
13196: WHERE t.transaction_temp_id = l_pick_slip_id
13197: AND t.standard_operation_id = bsor.standard_operation_id
13198: AND bsor.resource_id = bremp.resource_id
13199: AND bremp.resource_type = 2
13200: AND t.organization_id = l_org_id --Bug # 3704626
13201: AND ROWNUM < 2;

Line 13231: and t.standard_operation_id = bsor.standard_operation_id

13227: from mtl_material_transactions_temp t,
13228: bom_std_op_resources bsor,
13229: bom_resources breqp
13230: where t.transaction_temp_id = task_rec.task_id
13231: and t.standard_operation_id = bsor.standard_operation_id
13232: and bsor.resource_id = breqp.resource_id
13233: and breqp.resource_type = 1
13234: and rownum<2;
13235: */

Line 15069: , standard_operation_id

15065: , lpn_id
15066: , transfer_lpn_id
15067: , content_lpn_id
15068: , cartonization_id
15069: , standard_operation_id
15070: , wms_task_type
15071: , task_priority
15072: , container_item_id
15073: , operation_plan_id

Line 15266: , standard_operation_id

15262: , lpn_id
15263: , transfer_lpn_id
15264: , content_lpn_id
15265: , cartonization_id
15266: , standard_operation_id
15267: , wms_task_type
15268: , task_priority
15269: , container_item_id
15270: , operation_plan_id