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 10815: 'Standard',

10811: 'SHIPMENT_PRIORITY',
10812: DECODE(WDD.SHIPMENT_PRIORITY_CODE,
10813: 'High',
10814: 20,
10815: 'Standard',
10816: 10,
10817: NULL),
10818: 'INVOICE_VALUE',
10819: wms_replenishment_pvt.GET_SORT_INVOICE_VALUE(WDD.SOURCE_HEADER_ID,

Line 10853: 'Standard',

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

Line 10891: 'Standard',

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

Line 10929: 'Standard',

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

Line 10967: 'Standard',

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

Line 12588: , t.standard_operation_id

12584: END IF;
12585:
12586: SELECT bremp.resource_id role_id
12587: , t.wms_task_type
12588: , t.standard_operation_id
12589: , t.operation_plan_id
12590: , t.move_order_line_id
12591: INTO l_per_res_id
12592: , l_wms_task_type

Line 12598: AND t.standard_operation_id = bsor.standard_operation_id

12594: , l_operation_plan_id
12595: , l_move_order_line_id
12596: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
12597: WHERE t.transaction_temp_id = task_rec.task_id
12598: AND t.standard_operation_id = bsor.standard_operation_id
12599: AND bsor.resource_id = bremp.resource_id
12600: AND bremp.resource_type = 2
12601: AND ROWNUM < 2;
12602:

Line 12622: and t.standard_operation_id = bsor.standard_operation_id

12618: from mtl_material_transactions_temp t,
12619: bom_std_op_resources bsor,
12620: bom_resources breqp
12621: where t.transaction_temp_id = task_rec.task_id
12622: and t.standard_operation_id = bsor.standard_operation_id
12623: and bsor.resource_id = breqp.resource_id
12624: and breqp.resource_type = 1
12625: and rownum<2;
12626: */

Line 12933: , t.standard_operation_id

12929:
12930: BEGIN
12931: SELECT bremp.resource_id role_id
12932: , t.wms_task_type
12933: , t.standard_operation_id
12934: , t.operation_plan_id
12935: , t.move_order_line_id
12936: , t.inventory_item_id --Bug#6009436
12937: INTO l_per_res_id

Line 12945: AND t.standard_operation_id = bsor.standard_operation_id

12941: , l_move_order_line_id
12942: , l_item_id --Bug6009436
12943: FROM mtl_material_transactions_temp t, bom_std_op_resources bsor, bom_resources bremp
12944: WHERE t.transaction_temp_id = l_pick_slip_id
12945: AND t.standard_operation_id = bsor.standard_operation_id
12946: AND bsor.resource_id = bremp.resource_id
12947: AND bremp.resource_type = 2
12948: AND t.organization_id = l_org_id --Bug # 3704626
12949: AND ROWNUM < 2;

Line 12979: and t.standard_operation_id = bsor.standard_operation_id

12975: from mtl_material_transactions_temp t,
12976: bom_std_op_resources bsor,
12977: bom_resources breqp
12978: where t.transaction_temp_id = task_rec.task_id
12979: and t.standard_operation_id = bsor.standard_operation_id
12980: and bsor.resource_id = breqp.resource_id
12981: and breqp.resource_type = 1
12982: and rownum<2;
12983: */

Line 14669: , standard_operation_id

14665: , lpn_id
14666: , transfer_lpn_id
14667: , content_lpn_id
14668: , cartonization_id
14669: , standard_operation_id
14670: , wms_task_type
14671: , task_priority
14672: , container_item_id
14673: , operation_plan_id

Line 14866: , standard_operation_id

14862: , lpn_id
14863: , transfer_lpn_id
14864: , content_lpn_id
14865: , cartonization_id
14866: , standard_operation_id
14867: , wms_task_type
14868: , task_priority
14869: , container_item_id
14870: , operation_plan_id