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_WAVE_PLANNING_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1842: FROM mtl_material_transactions_temp mmtt1,

1838: wz2.zone_name) to_zone,
1839: mmtt1.transaction_uom,
1840: mmtt1.operation_plan_id,
1841: mmtt1.inventory_item_id
1842: FROM mtl_material_transactions_temp mmtt1,
1843: mtl_material_transactions_temp mmtt2,
1844: wms_zone_locators wzl1,
1845: wms_zone_locators wzl2,
1846: wms_zones_vl wz1,

Line 1843: mtl_material_transactions_temp mmtt2,

1839: mmtt1.transaction_uom,
1840: mmtt1.operation_plan_id,
1841: mmtt1.inventory_item_id
1842: FROM mtl_material_transactions_temp mmtt1,
1843: mtl_material_transactions_temp mmtt2,
1844: wms_zone_locators wzl1,
1845: wms_zone_locators wzl2,
1846: wms_zones_vl wz1,
1847: wms_zones_vl wz2

Line 1876: from mtl_material_transactions_temp mmtt,

1872: operation_plan_id,
1873: inventory_item_id,
1874: dropping_order,
1875: transaction_quantity
1876: from mtl_material_transactions_temp mmtt,
1877: MTL_SECONDARY_INVENTORIES MSI,
1878: wms_zone_locators wzl1,
1879: wms_zone_locators wzl2,
1880: wms_zones_vl wz1,

Line 1907: FROM mtl_material_transactions_temp mmtt1,

1903: mmtt1.transfer_subinventory,
1904: mmtt1.transaction_uom,
1905: mmtt1.operation_plan_id,
1906: mmtt1.inventory_item_id
1907: FROM mtl_material_transactions_temp mmtt1,
1908: mtl_material_transactions_temp mmtt2
1909: WHERE mmtt2.move_order_header_id = p_move_order_hdr_id
1910: AND (mmtt1.transaction_temp_id = mmtt2.transaction_temp_id OR
1911: mmtt1.transaction_temp_id = mmtt2.parent_line_id)

Line 1908: mtl_material_transactions_temp mmtt2

1904: mmtt1.transaction_uom,
1905: mmtt1.operation_plan_id,
1906: mmtt1.inventory_item_id
1907: FROM mtl_material_transactions_temp mmtt1,
1908: mtl_material_transactions_temp mmtt2
1909: WHERE mmtt2.move_order_header_id = p_move_order_hdr_id
1910: AND (mmtt1.transaction_temp_id = mmtt2.transaction_temp_id OR
1911: mmtt1.transaction_temp_id = mmtt2.parent_line_id)
1912: AND (mmtt2.parent_line_id IS NULL OR

Line 1924: from mtl_material_transactions_temp mmtt,

1920: operation_plan_id,
1921: inventory_item_id,
1922: dropping_order,
1923: transaction_quantity
1924: from mtl_material_transactions_temp mmtt,
1925: MTL_SECONDARY_INVENTORIES MSI
1926: where move_order_header_id = p_move_order_hdr_id
1927: AND mmtt.transfer_subinventory = msi.SECONDARY_INVENTORY_NAME
1928: AND mmtt.organization_id = msi.organization_id

Line 4643: mtl_material_transactions_temp mmtt,

4639: select mtrl.TXN_SOURCE_LINE_DETAIL_ID delivery_detail_id,
4640: sum(transaction_quantity) l_quantity,
4641: sum(secondary_transaction_quantity) l_quantity2
4642: from wms_wp_rules_simulation wwr,
4643: mtl_material_transactions_temp mmtt,
4644: mtl_txn_request_lines mtrl
4645: where wwr.delivery_detail_id = mtrl.TXN_SOURCE_LINE_DETAIL_ID
4646: and wwr.wave_header_id=p_wave_header_id
4647: AND mtrl.line_Id = mmtt.move_order_line_id

Line 4793: FROM mtl_material_transactions_temp mmtt1, mtl_material_transactions_temp mmtt2

4789: l_delMMTTserialctrl delMMTTserialctrl;
4790:
4791: CURSOR c_del_mmtt IS
4792: SELECT DISTINCT mmtt1.transaction_temp_id, mmtt1.transaction_header_id, mmtt1.ITEM_LOT_CONTROL_CODE, mmtt1.ITEM_SERIAL_CONTROL_CODE
4793: FROM mtl_material_transactions_temp mmtt1, mtl_material_transactions_temp mmtt2
4794: WHERE mmtt2.move_order_header_id=p_mo_header_id
4795: AND (mmtt1.transaction_temp_id=mmtt2.transaction_temp_id OR mmtt1.transaction_temp_id=mmtt2.parent_line_id);
4796:
4797:

Line 4888: DELETE FROM mtl_material_transactions_temp

4884:
4885: --FORALL i IN 1 ..l_tbl_count dbchange7
4886:
4887: FORALL i IN l_delMMTTtempid.FIRST ..l_delMMTTtempid.LAST
4888: DELETE FROM mtl_material_transactions_temp
4889: WHERE transaction_temp_id = l_delMMTTtempid(i);
4890:
4891:
4892:

Line 7110: mtl_material_transactions_temp mmtt,

7106: begin
7107: select sum(mmtt.transaction_quantity), Count(*), br.resource_type
7108: into l_transaction_quantity, l_number_of_tasks, l_resource_type
7109: from bom_resources br,
7110: mtl_material_transactions_temp mmtt,
7111: wms_dispatched_tasks wdt
7112: where mmtt.subinventory_code =
7113: l_resource_details.source_subinventory
7114: and mmtt.transfer_subinventory =

Line 7141: mtl_material_transactions_temp mmtt,

7137: begin
7138: select sum(mmtt.transaction_quantity), Count(*), br.resource_type
7139: into l_transaction_quantity, l_number_of_tasks, l_resource_type
7140: from bom_resources br,
7141: mtl_material_transactions_temp mmtt,
7142: wms_dispatched_tasks wdt,
7143: wms_zone_locators wzl1,
7144: wms_zone_locators wzl2,
7145: wms_zones_vl wz1,

Line 9029: FROM mtl_material_transactions_temp mmtt,

9025: l_organization_id number;
9026:
9027: CURSOR c_eqp_capacity(p_task_id NUMBER) IS
9028: SELECT distinct res_equip.inventory_item_id
9029: FROM mtl_material_transactions_temp mmtt,
9030: bom_resource_equipments res_equip,
9031: bom_resources res,
9032: bom_std_op_resources tt_x_res
9033: WHERE mmtt.transaction_temp_id = p_task_id

Line 9053: FROM mtl_material_transactions_temp mmtt,

9049: l_item_id,
9050: l_init_qty,
9051: l_item_prim_uom_code,
9052: l_organization_id
9053: FROM mtl_material_transactions_temp mmtt,
9054: mtl_item_locations mil,
9055: mtl_secondary_inventories msi,
9056: mtl_system_items item
9057: WHERE mmtt.transaction_temp_id = l_mmtt_tbl(i)

Line 9240: FROM mtl_material_transactions_temp mmtt,

9236: begin
9237:
9238: SELECT count(distinct mmtt.transaction_temp_id)
9239: into l_mmtt_count
9240: FROM mtl_material_transactions_temp mmtt,
9241: wsh_Delivery_details wdd,
9242: WSH_NEW_DELIVERIES WND,
9243: WSH_DELIVERY_ASSIGNMENTS WDA
9244: WHERE wdd.source_line_id = mmtt.trx_source_line_id

Line 9285: FROM mtl_material_transactions_temp mmtt,

9281: begin
9282:
9283: SELECT count(distinct mmtt.transaction_temp_id)
9284: into l_mmtt_count
9285: FROM mtl_material_transactions_temp mmtt,
9286: wsh_Delivery_details wdd,
9287: WSH_NEW_DELIVERIES WND,
9288: WSH_DELIVERY_ASSIGNMENTS WDA
9289: WHERE wdd.source_line_id = mmtt.trx_source_line_id

Line 9392: FROM mtl_material_transactions_temp mmtt,

9388: -- order by wdd.shipment_priority_code;
9389:
9390: CURSOR c_rc_wdds is
9391: SELECT distinct wdd.delivery_detail_id
9392: FROM mtl_material_transactions_temp mmtt,
9393: mtl_txn_request_lines mtrl,
9394: wsh_Delivery_details wdd
9395: WHERE mmtt.move_order_line_id = mtrl.line_id
9396: AND wdd.source_line_id = mmtt.trx_source_line_id

Line 9412: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

9408: AND (WDD.BATCH_ID IN
9409: ( SELECT WDD.BATCH_ID --bug14534180
9410: FROM WSH_DELIVERY_DETAILS WDD,
9411: MTL_TXN_REQUEST_LINES MTRL,
9412: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
9413: WHERE MMTT.MOVE_ORDER_LINE_ID = MTRL.LINE_ID
9414: AND WDD.SOURCE_LINE_ID = MMTT.TRX_SOURCE_LINE_ID
9415: AND MTRL.CARTON_GROUPING_ID = p_carton_grouping_id))
9416: UNION ALL

Line 9425: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

9421: ( SELECT SELECTED_BATCH_ID
9422: FROM WSH_PICKING_BATCHES WPB,
9423: MTL_TXN_REQUEST_LINES MTRL,
9424: WSH_DELIVERY_DETAILS WDD2,
9425: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
9426: WHERE MMTT.MOVE_ORDER_LINE_ID = MTRL.LINE_ID
9427: AND WDD2.SOURCE_LINE_ID = MMTT.TRX_SOURCE_LINE_ID
9428: AND WPB.BATCH_ID = WDD2.BATCH_ID
9429: AND MTRL.CARTON_GROUPING_ID = p_carton_grouping_id))

Line 9484: FROM mtl_material_transactions_temp mmtt,

9480: and wts.trip_id is not null; -- Get All Trips for tasks in UnReleased Status
9481:
9482: CURSOR c_get_trip_Stop is
9483: SELECT distinct wts.stop_id stop_id, wts.STOP_SEQUENCE_NUMBER
9484: FROM mtl_material_transactions_temp mmtt,
9485: wsh_Delivery_details wdd,
9486: WSH_NEW_DELIVERIES WND,
9487: WSH_DELIVERY_ASSIGNMENTS WDA,
9488: WSH_TRIP_STOPS WTS,

Line 9500: FROM mtl_material_transactions_temp mmtt,

9496: ORDER BY wts.STOP_SEQUENCE_NUMBER desc;
9497:
9498: CURSOR c_get_mmtt is
9499: SELECT distinct mmtt.transaction_temp_id transaction_temp_id
9500: FROM mtl_material_transactions_temp mmtt,
9501: wsh_Delivery_details wdd,
9502: WSH_NEW_DELIVERIES WND,
9503: WSH_DELIVERY_ASSIGNMENTS WDA,
9504: WSH_TRIP_STOPS WTS,

Line 9677: from wsh_delivery_details wdd, mtl_material_transactions_temp mmtt

9673:
9674: cursor c_carton_lines is
9675: select wdd.delivery_Detail_id, mmtt.move_order_line_id
9676: -- into p_line_rows(l1), p_move_order_line_tbl(l1)
9677: from wsh_delivery_details wdd, mtl_material_transactions_temp mmtt
9678: where wdd.Source_line_id = mmtt.trx_source_line_id
9679: AND Nvl(wdd.REPLENISHMENT_STATUS, 'C') = 'C'
9680: and mmtt.transaction_temp_id in
9681: (select * from table(wms_wave_planning_pvt.list_mmtt_release)); --11870443

Line 10850: update mtl_material_transactions_temp

10846: line_count := line_count + 1;
10847: end loop;
10848:
10849: forall i3 in p_move_order_line_tbl.FIRST .. p_move_order_line_tbl.LAST
10850: update mtl_material_transactions_temp
10851: set move_order_header_id = l_x_trohdr_rec.header_id
10852: where move_order_line_id = p_move_order_line_tbl(i3);
10853:
10854: /*

Line 10927: UPDATE mtl_material_transactions_temp

10923:
10924: end if;
10925:
10926: forall i IN g_mmtt_table.FIRST .. g_mmtt_table.LAST --11870443 change to global g_mmtt_table 11870443
10927: UPDATE mtl_material_transactions_temp
10928: SET wms_task_status = 1
10929: WHERE transaction_temp_id = g_mmtt_table(i) --11870443 change to global g_mmtt_table 11870443
10930: and wms_task_status = 8;
10931:

Line 14428: mtl_material_transactions_temp mmtt,

14424: IF p_to_status_id IN (1, 8) THEN
14425: SELECT wwtt.transaction_temp_id, wwtt.task_type_id, wwtt.status BULK COLLECT
14426: INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
14427: FROM wms_wp_tasks_gtmp wwtt,
14428: mtl_material_transactions_temp mmtt,
14429: WMS_DISPATCHED_TASKS wdt
14430: WHERE wwtt.transaction_temp_id = wdt.transaction_temp_id
14431: AND wwtt.transaction_temp_id = mmtt.transaction_temp_id
14432: AND wwtt.RESULT = 'X'

Line 14442: FROM mtl_material_transactions_temp mmtt1

14438: AND wdt2.status = 9
14439: AND wdt2.task_method IS NOT NULL
14440: AND wdt2.transaction_temp_id IN
14441: (SELECT transaction_temp_id
14442: FROM mtl_material_transactions_temp mmtt1
14443: WHERE DECODE(wdt.TASK_METHOD,
14444: 'CARTON',
14445: mmtt1.cartonization_id,
14446: 'PICK_SLIP',

Line 14773: TYPE transaction_temp_id_table_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;

14769: x_save_count OUT NOCOPY NUMBER,
14770: x_return_status OUT NOCOPY VARCHAR2,
14771: x_msg_data OUT NOCOPY VARCHAR2,
14772: x_msg_count OUT NOCOPY NUMBER) IS
14773: TYPE transaction_temp_id_table_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
14774:
14775: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE INDEX BY BINARY_INTEGER;
14776:
14777: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE INDEX BY BINARY_INTEGER;

Line 14775: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE INDEX BY BINARY_INTEGER;

14771: x_msg_data OUT NOCOPY VARCHAR2,
14772: x_msg_count OUT NOCOPY NUMBER) IS
14773: TYPE transaction_temp_id_table_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
14774:
14775: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE INDEX BY BINARY_INTEGER;
14776:
14777: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE INDEX BY BINARY_INTEGER;
14778:
14779: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE INDEX BY BINARY_INTEGER;

Line 14777: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE INDEX BY BINARY_INTEGER;

14773: TYPE transaction_temp_id_table_type IS TABLE OF mtl_material_transactions_temp.transaction_temp_id%TYPE INDEX BY BINARY_INTEGER;
14774:
14775: TYPE wms_task_status_table_type IS TABLE OF mtl_material_transactions_temp.wms_task_status%TYPE INDEX BY BINARY_INTEGER;
14776:
14777: TYPE task_priority_table_type IS TABLE OF mtl_material_transactions_temp.task_priority%TYPE INDEX BY BINARY_INTEGER;
14778:
14779: TYPE person_id_table_type IS TABLE OF wms_dispatched_tasks.person_id%TYPE INDEX BY BINARY_INTEGER;
14780:
14781: TYPE person_resource_id_table_type IS TABLE OF wms_dispatched_tasks.person_resource_id%TYPE /* Bug 5630187 */

Line 14835: FROM mtl_material_transactions_temp

14831: --Patchset J: Bulk picking
14832: --Get the transaction_temp_id of the children tasks
14833: CURSOR bulk_children_tasks_cur(trx_temp_id NUMBER) IS
14834: SELECT transaction_temp_id
14835: FROM mtl_material_transactions_temp
14836: WHERE parent_line_id = trx_temp_id
14837: AND transaction_temp_id <> trx_temp_id
14838: FOR UPDATE nowait;
14839: --end bulk picking

Line 14891: FROM mtl_material_transactions_temp mmtt,

14887:
14888: IF rec_wwtt.task_type_id <> 3 THEN
14889: SELECT mmtt.transaction_temp_id
14890: INTO l_transaction_temp_id_table(i)
14891: FROM mtl_material_transactions_temp mmtt,
14892: wms_dispatched_tasks wdt
14893: WHERE mmtt.transaction_temp_id = rec_wwtt.transaction_temp_id
14894: AND mmtt.transaction_temp_id = wdt.transaction_temp_id(+)
14895: AND mmtt.wms_task_type = wdt.task_type(+)

Line 14972: UPDATE mtl_material_transactions_temp

14968: end if;
14969:
14970: IF l_non_cycle_count_number > 0 THEN
14971: FORALL i IN l_transaction_temp_id_table.FIRST .. l_transaction_temp_id_table.LAST
14972: UPDATE mtl_material_transactions_temp
14973: SET wms_task_status = DECODE(l_wms_task_status_table(i),
14974: 8,
14975: 8,
14976: 1,

Line 15149: FUNCTION getforcesignonflagvalue(p_transaction_temp_id IN mtl_material_transactions_temp.transaction_temp_id%TYPE,

15145: x_msg_data := SQLERRM;
15146: print_DEBUG('SQL error: ' || SQLERRM, l_debug);
15147: END save_tasks;
15148:
15149: FUNCTION getforcesignonflagvalue(p_transaction_temp_id IN mtl_material_transactions_temp.transaction_temp_id%TYPE,
15150: p_device_id OUT NOCOPY NUMBER)
15151: RETURN VARCHAR2 IS
15152: l_force_sign_on wms_devices_b.force_sign_on_flag%TYPE;
15153: BEGIN

Line 15158: FROM mtl_material_transactions_temp mmtt

15154: SELECT wms_task_dispatch_device.get_eligible_device(mmtt.organization_id,
15155: mmtt.subinventory_code,
15156: mmtt.locator_id)
15157: INTO p_device_id
15158: FROM mtl_material_transactions_temp mmtt
15159: WHERE mmtt.transaction_temp_id = p_transaction_temp_id;
15160:
15161: SELECT force_sign_on_flag
15162: INTO l_force_sign_on

Line 15192: FROM wms_wp_tasks_gtmp wwtt, mtl_material_transactions_temp mmtt

15188: --MMTT used to get children task.
15189: --wwtt used to get the parent task.
15190: SELECT COUNT(1), wwtt.transaction_temp_id BULK COLLECT
15191: INTO l_num_of_child_tasks_tbl, l_parent_temp_ids_tbl
15192: FROM wms_wp_tasks_gtmp wwtt, mtl_material_transactions_temp mmtt
15193: WHERE wwtt.transaction_temp_id = mmtt.parent_line_id
15194: AND wwtt.transaction_temp_id <> mmtt.transaction_temp_id
15195: GROUP BY wwtt.transaction_temp_id;
15196:

Line 15446: FROM wsh_delivery_details wdd, mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt

15442: --also modified to join with wdt
15443: SELECT Sum(Decode(Nvl(wdt.status,0), 4, 1, 0)) loaded,
15444: Count(1) total_tasked
15445: into v_loaded, v_total
15446: FROM wsh_delivery_details wdd, mtl_material_transactions_temp mmtt, wms_dispatched_tasks wdt
15447: WHERE wdd.delivery_detail_id = p_Delivery_Detail_id
15448: AND wdd.move_order_line_id = mmtt.move_order_line_id
15449: AND wdt.transaction_temp_id (+) = mmtt.TRANSACTION_temp_id;
15450:

Line 17066: mtl_material_transactions_temp mmtt';

17062: -------------------------------------------------------------------------------------------------------------
17063: --11775489 get from wdd... FIXED changed to move_order_line_id similar to other bug
17064: l_select_query := 'select mmtt.TRANSACTION_TEMP_ID, mmtt.wms_task_type';
17065: l_from_query := ' from wms_wp_wave_lines wwl,wsh_delivery_details wdd,
17066: mtl_material_transactions_temp mmtt';
17067: l_where_query := ' where wwl.wave_header_id = :wave_id
17068: and wdd.delivery_detail_id = wwl.delivery_detail_id
17069: and wdd.organization_id = wwl.organization_id
17070: and wdd.move_order_line_id = mmtt.move_order_line_id';

Line 17628: FROM mtl_material_transactions_temp mtrl,

17624: l_prim_qty,
17625: l_sec_qty,
17626: l_org_id,
17627: l_mo_type
17628: FROM mtl_material_transactions_temp mtrl,
17629: mtl_txn_request_headers mtrh
17630: WHERE mtrl.transaction_temp_id = l_txn_temp_id
17631: AND mtrh.header_id = mtrl.move_order_header_id;
17632:

Line 17661: FROM mtl_material_transactions_temp

17657: -- pick release task
17658: BEGIN
17659: SELECT COUNT(*)
17660: INTO l_no_mmtt
17661: FROM mtl_material_transactions_temp
17662: WHERE move_order_line_id = l_mol_id;
17663:
17664:
17665: SELECT delivery_detail_id,

Line 18380: FROM mtl_material_transactions_temp mmtt,

18376: FROM WMS_LICENSE_PLATE_NUMBERS
18377: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) PICKED_LPN,
18378: mmtt.transaction_uom,
18379: mmtt.transaction_quantity
18380: FROM mtl_material_transactions_temp mmtt,
18381: WSH_DELIVERY_DETAILS WDD,
18382: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18383: mtl_system_items_kfv msiv,
18384: wms_op_plans_vl wopv,

Line 18487: (select count(1) from mtl_material_transactions_temp where parent_line_id = mmtt.transaction_temp_id and transaction_temp_id <> mmtt.transaction_temp_id) num_of_child_tasks,

18483: null shipment_date,
18484: null shipment_priority,
18485: MMTT.DEPARTMENT_CODE,
18486: 'N' CHILD_TASKS,
18487: (select count(1) from mtl_material_transactions_temp where parent_line_id = mmtt.transaction_temp_id and transaction_temp_id <> mmtt.transaction_temp_id) num_of_child_tasks,
18488: (SELECT LICENSE_PLATE_NUMBER
18489: FROM WMS_LICENSE_PLATE_NUMBERS
18490: WHERE LPN_ID = MMTT.ALLOCATED_LPN_ID) ALLOCATED_LPN,
18491: (SELECT LICENSE_PLATE_NUMBER

Line 18511: FROM mtl_material_transactions_temp mmtt,

18507: FROM WMS_LICENSE_PLATE_NUMBERS
18508: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) PICKED_LPN,
18509: mmtt.transaction_uom,
18510: mmtt.transaction_quantity
18511: FROM mtl_material_transactions_temp mmtt,
18512: mtl_material_transactions_temp mmtt2, --12736677
18513: WSH_DELIVERY_DETAILS WDD,
18514: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18515: mtl_system_items_kfv msiv,

Line 18512: mtl_material_transactions_temp mmtt2, --12736677

18508: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) PICKED_LPN,
18509: mmtt.transaction_uom,
18510: mmtt.transaction_quantity
18511: FROM mtl_material_transactions_temp mmtt,
18512: mtl_material_transactions_temp mmtt2, --12736677
18513: WSH_DELIVERY_DETAILS WDD,
18514: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18515: mtl_system_items_kfv msiv,
18516: wms_op_plans_vl wopv,

Line 18661: FROM mtl_material_transactions_temp mmtt,

18657: FROM WMS_LICENSE_PLATE_NUMBERS
18658: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) PICKED_LPN,
18659: mmtt.transaction_uom,
18660: mmtt.transaction_quantity
18661: FROM mtl_material_transactions_temp mmtt,
18662: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
18663: mtl_system_items_kfv msiv,
18664: wms_op_plans_vl wopv,
18665: per_all_people_f pap,

Line 18998: FROM mtl_material_transactions_temp mmtt,

18994: FROM WMS_LICENSE_PLATE_NUMBERS
18995: WHERE LPN_ID = MMTT.CONTENT_LPN_ID) PICKED_LPN,
18996: mmtt.transaction_uom,
18997: mmtt.transaction_quantity
18998: FROM mtl_material_transactions_temp mmtt,
18999: WSH_DELIVERY_DETAILS WDD,
19000: MTL_ITEM_LOCATIONS_kfv mil, --bug12642410
19001: mtl_system_items_kfv msiv,
19002: wms_op_plans_vl wopv,

Line 19354: mtl_material_transactions_temp mmtt,

19350: wdd.requested_quantity_uom) *
19351: Nvl(MMTT.TRANSACTION_QUANTITY, 0)))
19352: into l_allocated_quantity
19353: from wsh_delivery_details wdd,
19354: mtl_material_transactions_temp mmtt,
19355: wms_wp_wave_lines wwl
19356: where wdd.move_order_line_id = mmtt.move_order_line_id
19357: and wdd.delivery_detail_id = wwl.delivery_detail_id
19358: and wdd.organization_id = wwl.organization_id