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.

[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on WMS_WP_TP_MMTT

Line 9385: from wms_wp_tp_mmtt

9381: WHERE wwtt.move_order_line_id = mtrl.line_id
9382: and wdd.source_line_id = wwtt.transaction_source_line_id
9383: and wwtt.transaction_temp_id in
9384: (select transaction_temp_id
9385: from wms_wp_tp_mmtt
9386: where indicator_flag = 'C')
9387: and wwtt.status_id = 8; --- Ajith????????????
9388: -- order by wdd.shipment_priority_code;
9389:

Line 9438: from wms_wp_tp_mmtt

9434: FROM wms_waveplan_tasks_temp wwtt, mtl_txn_request_lines mtrl
9435: WHERE wwtt.move_order_line_id = mtrl.line_id
9436: and wwtt.transaction_temp_id in
9437: (select transaction_temp_id
9438: from wms_wp_tp_mmtt
9439: where indicator_flag = 'C')
9440: AND mtrl.carton_grouping_id = p_carton_grouping_id;
9441:
9442: -- Minimum Equipment Capacity

Line 9477: from wms_wp_tp_mmtt

9473: AND WTS.STOP_ID(+) = WLG.DROP_OFF_STOP_ID
9474: AND WLG.DELIVERY_ID(+) = WND.DELIVERY_ID
9475: and wwtt.transaction_temp_id in
9476: (select transaction_temp_id
9477: from wms_wp_tp_mmtt
9478: where indicator_flag = 'F') --- Ajith????????????
9479: and wwtt.status_id = 8
9480: and wts.trip_id is not null; -- Get All Trips for tasks in UnReleased Status
9481:

Line 9514: from wms_wp_tp_mmtt

9510: AND WTS.STOP_ID(+) = WLG.DROP_OFF_STOP_ID
9511: AND WLG.DELIVERY_ID(+) = WND.DELIVERY_ID
9512: /* and wwtt.transaction_temp_id in
9513: (select transaction_temp_id
9514: from wms_wp_tp_mmtt
9515: where indicator_flag = 'F') --- Ajith???????????? */
9516: -- AND wwtt.status_id <> 6
9517: -- ORDER BY wts.STOP_SEQUENCE_NUMBER desc
9518: union

Line 9534: from wms_wp_tp_mmtt

9530: AND WTS.STOP_ID(+) = WLG.DROP_OFF_STOP_ID
9531: AND WLG.DELIVERY_ID(+) = WND.DELIVERY_ID
9532: /* and wwtt.transaction_temp_id in
9533: (select transaction_temp_id
9534: from wms_wp_tp_mmtt
9535: where indicator_flag = 'F') --- Ajith???????????? */
9536: -- AND wwtt.status_id <> 6
9537: -- ORDER BY wts.STOP_SEQUENCE_NUMBER desc
9538: ;

Line 9550: from wms_wp_tp_mmtt

9546: and wwtt.to_organization_id = mil.organization_id
9547: and mil.inventory_location_type in (4, 5)
9548: and wwtt.transaction_temp_id in
9549: (select transaction_temp_id
9550: from wms_wp_tp_mmtt
9551: where indicator_flag = 'T') --- Ajith????????????
9552: and wwtt.status_id = 8; -- We get only the Un Released Lines Delivery.
9553:
9554: p_consol_locator_id number;

Line 9606: from wms_wp_tp_mmtt

9602: WSH_DELIVERY_ASSIGNMENTS WDA
9603: WHERE wdd.source_line_id = wwtt.transaction_source_line_id
9604: and wwtt.transaction_temp_id in
9605: (select transaction_temp_id
9606: from wms_wp_tp_mmtt
9607: where indicator_flag = 'T') --- Ajith????????????
9608: AND WND.DELIVERY_ID(+) = WDA.DELIVERY_ID
9609: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
9610: and wwtt.status_id = 8 -- We get only the Un Released Lines Delivery.

Line 9627: from wms_wp_tp_mmtt

9623: WHERE WND.DELIVERY_ID = p_delivery_mmtt_id
9624: and wdd.source_line_id = wwtt.transaction_source_line_id
9625: and wwtt.transaction_temp_id in
9626: (select transaction_temp_id
9627: from wms_wp_tp_mmtt
9628: where indicator_flag = 'T')
9629: AND WND.DELIVERY_ID(+) = WDA.DELIVERY_ID
9630: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID;
9631:

Line 10022: insert into wms_wp_tp_mmtt values (l_final_mmtt_table(m), 'N');

10018: print_DEBUG(' Total Number of Tasks is ' || l_final_mmtt_table.count,
10019: l_debug);
10020:
10021: forall m in l_final_mmtt_table.FIRST .. l_final_mmtt_table.LAST
10022: insert into wms_wp_tp_mmtt values (l_final_mmtt_table(m), 'N');
10023:
10024: /*
10025: for l_rec in c_wave_temp loop
10026:

Line 10105: update wms_wp_tp_mmtt

10101: Capacity ',
10102: l_debug);
10103:
10104: forall i in g_mmtt_table.FIRST .. g_mmtt_table.LAST --11870443 change to global g_mmtt_table 11870443
10105: update wms_wp_tp_mmtt
10106: set indicator_flag = 'F'
10107: where transaction_temp_id = g_mmtt_table(i); --11870443 change to global g_mmtt_table 11870443
10108: -- and indicator_flag <> 'Y';
10109:

Line 10140: update wms_wp_tp_mmtt

10136:
10137: if l_fill_capacity = 'Y' then
10138:
10139: /* forall i in l_mmtt_table.FIRST .. l_mmtt_table.LAST
10140: update wms_wp_tp_mmtt
10141: set indicator_flag = 'Y'
10142: where transaction_temp_id = l_mmtt_table(i); */
10143: g_mmtt_table.DELETE; --11870443 change to global g_mmtt_table 11870443
10144: else

Line 10147: update wms_wp_tp_mmtt

10143: g_mmtt_table.DELETE; --11870443 change to global g_mmtt_table 11870443
10144: else
10145:
10146: forall i in l_final_mmtt_table.FIRST .. l_final_mmtt_table.LAST
10147: update wms_wp_tp_mmtt
10148: set indicator_flag = 'F'
10149: where transaction_temp_id = l_final_mmtt_table(i);
10150:
10151: end if;

Line 10199: from wms_wp_tp_mmtt

10195: -- Need to find out whether the Tasks belong to the Query
10196: begin
10197: select 1
10198: into l_unreleased_count
10199: from wms_wp_tp_mmtt
10200: where indicator_flag = 'F'
10201: and transaction_temp_id = l_task.transaction_temp_id;
10202:
10203: exception

Line 10249: update wms_wp_tp_mmtt

10245: end loop;
10246: end loop;
10247:
10248: forall i in g_mmtt_table.FIRST .. g_mmtt_table.LAST --11870443 change to global g_mmtt_table 11870443
10249: update wms_wp_tp_mmtt
10250: set indicator_flag = 'T'
10251: where transaction_temp_id = g_mmtt_table(i); --11870443 change to global g_mmtt_table 11870443
10252: -- and indicator_flag <> 'Y';
10253: -- l_mmtt_table1.DELETE;

Line 10279: update wms_wp_tp_mmtt

10275:
10276: elsif (l_fill_capacity = 'Y' and l_reverse_trip_Stop <> 'Y') then
10277:
10278: forall i in g_mmtt_table.FIRST .. g_mmtt_table.LAST --11870443 change to global g_mmtt_table 11870443
10279: update wms_wp_tp_mmtt
10280: set indicator_flag = 'T'
10281: where transaction_temp_id = g_mmtt_table(i); --11870443 change to global g_mmtt_table 11870443
10282:
10283: else

Line 10286: update wms_wp_tp_mmtt

10282:
10283: else
10284:
10285: forall i in l_final_mmtt_table.FIRST .. l_final_mmtt_table.LAST
10286: update wms_wp_tp_mmtt
10287: set indicator_flag = 'T'
10288: where transaction_temp_id = l_final_mmtt_table(i);
10289:
10290: end if;

Line 10415: update wms_wp_tp_mmtt

10411:
10412: close c_get_mmtt_delivery;
10413:
10414: forall i in l_mmtt_table2.FIRST .. l_mmtt_table2.LAST
10415: update wms_wp_tp_mmtt
10416: set indicator_flag = 'C'
10417: where transaction_temp_id = l_mmtt_table2(i);
10418:
10419: -- l_mmtt_table.delete;

Line 10463: update wms_wp_tp_mmtt

10459: if (l_fill_capacity = 'Y' or l_reverse_trip_Stop = 'Y' or
10460: l_consol_locator = 'Y') then
10461:
10462: forall i in g_mmtt_table.FIRST .. g_mmtt_table.LAST --11870443 change to global g_mmtt_table 11870443
10463: update wms_wp_tp_mmtt
10464: set indicator_flag = 'C'
10465: where transaction_temp_id = g_mmtt_table(i); --11870443 change to global g_mmtt_table 11870443
10466:
10467: else

Line 10470: update wms_wp_tp_mmtt

10466:
10467: else
10468:
10469: forall i in l_final_mmtt_table.FIRST .. l_final_mmtt_table.LAST
10470: update wms_wp_tp_mmtt
10471: set indicator_flag = 'C'
10472: where transaction_temp_id = l_final_mmtt_table(i);
10473:
10474: select transaction_temp_id bulk collect

Line 10476: from wms_wp_tp_mmtt

10472: where transaction_temp_id = l_final_mmtt_table(i);
10473:
10474: select transaction_temp_id bulk collect
10475: into g_mmtt_table --11870443 change to global g_mmtt_table 11870443
10476: from wms_wp_tp_mmtt
10477: where indicator_flag = 'C';
10478:
10479: end if;
10480:

Line 10733: update wms_wp_tp_mmtt

10729:
10730: close c_rc_tasks;
10731:
10732: forall i in g_mmtt_table.FIRST .. g_mmtt_table.LAST --11870443 change to global g_mmtt_table 11870443
10733: update wms_wp_tp_mmtt
10734: set indicator_flag = 'L'
10735: where transaction_temp_id = g_mmtt_table(i); --11870443 change to global g_mmtt_table 11870443
10736:
10737: g_mmtt_table.delete; --11870443 change to global g_mmtt_table 11870443

Line 10758: from wms_wp_tp_mmtt

10754: end loop;
10755:
10756: select transaction_temp_id bulk collect
10757: into g_mmtt_table --11870443 change to global g_mmtt_table 11870443
10758: from wms_wp_tp_mmtt
10759: where indicator_flag = 'L';
10760:
10761: exception
10762: WHEN OTHERS THEN