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 WSH_DELIVERY_LEGS

Line 5353: wsh_delivery_legs wdl,

5349: FROM wms_wp_wave_lines wwl, --11775489 get from wdd... FIXED...check performance impact
5350: wsh_delivery_details wdd,
5351: wsh_delivery_assignments wda,
5352: wsh_new_deliveries wnd,
5353: wsh_delivery_legs wdl,
5354: wsh_trip_stops wts,
5355: wms_dock_appointments_b wdab
5356: WHERE wwl.organization_id = l_organization_id
5357: AND wwl.wave_header_id = p_wave_header_id

Line 7210: wsh_delivery_legs wdl,

7206: FROM wms_wp_wave_lines wwl, --11775489 get from wdd... FIXED check performance impact
7207: wsh_delivery_details wdd,
7208: wsh_delivery_assignments wda,
7209: wsh_new_deliveries wnd,
7210: wsh_delivery_legs wdl,
7211: wsh_trip_stops wts,
7212: wms_dock_appointments_b wdab
7213: WHERE wwl.organization_id = l_org_id
7214: AND wwl.wave_header_id = p_wave_header_id

Line 9469: WSH_DELIVERY_LEGS WLG

9465: wsh_Delivery_details wdd,
9466: WSH_NEW_DELIVERIES WND,
9467: WSH_DELIVERY_ASSIGNMENTS WDA,
9468: WSH_TRIP_STOPS WTS,
9469: WSH_DELIVERY_LEGS WLG
9470: WHERE WND.DELIVERY_ID(+) = WDA.DELIVERY_ID
9471: AND wdd.source_line_id = wwtt.transaction_source_line_id
9472: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
9473: AND WTS.STOP_ID(+) = WLG.DROP_OFF_STOP_ID

Line 9489: WSH_DELIVERY_LEGS WLG

9485: wsh_Delivery_details wdd,
9486: WSH_NEW_DELIVERIES WND,
9487: WSH_DELIVERY_ASSIGNMENTS WDA,
9488: WSH_TRIP_STOPS WTS,
9489: WSH_DELIVERY_LEGS WLG
9490: WHERE WND.DELIVERY_ID(+) = WDA.DELIVERY_ID
9491: and wts.trip_id = l_trip_id
9492: AND wdd.source_line_id = mmtt.trx_source_line_id
9493: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID

Line 9505: WSH_DELIVERY_LEGS WLG

9501: wsh_Delivery_details wdd,
9502: WSH_NEW_DELIVERIES WND,
9503: WSH_DELIVERY_ASSIGNMENTS WDA,
9504: WSH_TRIP_STOPS WTS,
9505: WSH_DELIVERY_LEGS WLG
9506: WHERE wts.stop_id = l_stop_id
9507: AND wdd.source_line_id = mmtt.trx_source_line_id
9508: AND WND.DELIVERY_ID(+) = WDA.DELIVERY_ID
9509: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID

Line 9525: WSH_DELIVERY_LEGS WLG

9521: wsh_Delivery_details wdd,
9522: WSH_NEW_DELIVERIES WND,
9523: WSH_DELIVERY_ASSIGNMENTS WDA,
9524: WSH_TRIP_STOPS WTS,
9525: WSH_DELIVERY_LEGS WLG
9526: WHERE wts.stop_id = l_stop_id
9527: AND wdd.source_line_id = mmt.trx_source_line_id
9528: AND WND.DELIVERY_ID(+) = WDA.DELIVERY_ID
9529: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID

Line 13101: ' WSH_DELIVERY_LEGS WLG,' ||

13097: g_Unreleased_SQL := g_Unreleased_SQL ||
13098: ' FROM WSH_DELIVERY_DETAILS WDD,' ||
13099: ' WSH_NEW_DELIVERIES WDE,' ||
13100: ' WSH_DELIVERY_ASSIGNMENTS WDA,' ||
13101: ' WSH_DELIVERY_LEGS WLG,' ||
13102: ' WSH_TRIP_STOPS WTS, ' ||
13103: ' WMS_DOCK_APPOINTMENTS_B WDO ';
13104:
13105: FOR CUR_REC IN C_ADVANCED_CONDITION LOOP

Line 15520: wsh_delivery_legs wdl,

15516: LOWER(wave_status) in ('released', 'completed'))
15517: OR (p_wave IS NULL AND
15518: LOWER(wave_status) in ('released', 'completed'))) wwh,
15519: wsh_delivery_assignments wda,
15520: wsh_delivery_legs wdl,
15521: wsh_new_deliveries wnd,
15522: wsh_trip_stops wts,
15523: wms_dock_appointments_b wdab
15524: WHERE wwl.wave_header_id = wwh.wave_id

Line 15543: wsh_delivery_legs wdl,

15539: nvl(wdab.end_time, wts.planned_arrival_date) date_scheduled
15540: FROM wms_wp_wave_lines wwl, --11775489 added org_id join...
15541: wsh_delivery_details wdd,
15542: wsh_delivery_assignments wda,
15543: wsh_delivery_legs wdl,
15544: wsh_new_deliveries wnd,
15545: wsh_trip_stops wts,
15546: wms_dock_appointments_b wdab
15547: WHERE wwl.wave_header_id = p_wave_id

Line 15569: wsh_delivery_legs wdl,

15565: wnd.earliest_pickup_date))) date_scheduled
15566: FROM wms_wp_wave_lines wwl, --11775489 added org_id join...
15567: wsh_delivery_details wdd,
15568: wsh_delivery_assignments wda,
15569: wsh_delivery_legs wdl,
15570: wsh_new_deliveries wnd,
15571: wsh_trip_stops wts,
15572: wms_dock_appointments_b wdab
15573: WHERE wwl.wave_header_id = p_wave_id

Line 15600: wsh_delivery_legs wdl,

15596: wdd.date_scheduled))))) date_scheduled
15597: FROM wms_wp_wave_lines wwl, --11775489 added org_id join...
15598: wsh_delivery_details wdd,
15599: wsh_delivery_assignments wda,
15600: wsh_delivery_legs wdl,
15601: wsh_new_deliveries wnd,
15602: wsh_trip_stops wts,
15603: wms_dock_appointments_b wdab
15604: WHERE wwl.wave_header_id = p_wave_id

Line 15617: wsh_delivery_legs wdl,

15613: and nvl(wwl.remove_from_Wave_flag, 'N') <> 'Y' --11775489 filter out lines no longer in wave
15614: GROUP BY wdd.source_header_id) shi,
15615: wsh_delivery_details wdd,
15616: wsh_delivery_assignments wda,
15617: wsh_delivery_legs wdl,
15618: wsh_new_deliveries wnd,
15619: wsh_trip_stops wts
15620: WHERE wdd.source_header_id = shi.source_header_id
15621: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 15643: wsh_delivery_legs wdl,

15639: wdd.date_scheduled))))) date_scheduled
15640: FROM wms_wp_wave_lines wwl, --11775489 added org_id join...
15641: wsh_delivery_details wdd,
15642: wsh_delivery_assignments wda,
15643: wsh_delivery_legs wdl,
15644: wsh_new_deliveries wnd,
15645: wsh_trip_stops wts,
15646: wms_dock_appointments_b wdab
15647: WHERE wwl.wave_header_id = p_wave_id

Line 15661: wsh_delivery_legs wdl,

15657: GROUP BY wdd.source_line_id) shi,
15658: wms_wp_wave_lines wwl,--11775489 added org_id join...
15659: wsh_delivery_details wdd,
15660: wsh_delivery_assignments wda,
15661: wsh_delivery_legs wdl,
15662: wsh_new_deliveries wnd,
15663: wsh_trip_stops wts
15664: WHERE wdd.source_line_id = shi.source_line_id
15665: AND wdd.delivery_detail_id = wwl.delivery_detail_id

Line 17079: wsh_delivery_legs wdl, wsh_trip_stops wts';

17075: print_debug('Nothing to Do here' || l_final_query, l_debug);
17076: ELSIF (p_entity = 'Trip') THEN
17077: l_from_query := l_from_query ||
17078: ' ,wsh_delivery_assignments wda, wsh_new_deliveries wnd,
17079: wsh_delivery_legs wdl, wsh_trip_stops wts';
17080: l_where_query := l_where_query ||
17081: ' and wdd.delivery_detail_id = wda.delivery_detail_id
17082: and wda.delivery_id = wnd.delivery_id
17083: and wnd.delivery_id = wdl.delivery_id

Line 17428: wsh_delivery_legs wdl,wsh_trip_stops wts';

17424: print_debug('No more changes in any string', l_debug);
17425: ELSIF (p_entity = 'Trip') THEN
17426: l_from_query := l_from_query ||
17427: ' , wsh_delivery_assignments wda, wsh_new_deliveries wnd,
17428: wsh_delivery_legs wdl,wsh_trip_stops wts';
17429: l_where_query := l_where_query ||
17430: ' and wda.delivery_detail_id = wdd.delivery_detail_id
17431: and wda.delivery_id = wnd.delivery_id(+)
17432: and wnd.delivery_id = wdl.delivery_id(+)

Line 18164: WSH_DELIVERY_LEGS WLG,

18160: MTL_PARAMETERS MP,
18161: WMS_LICENSE_PLATE_NUMBERS WLPN,
18162: WSH_DELIVERY_ASSIGNMENTS WDA,
18163: WSH_TRIP_STOPS WTS,
18164: WSH_DELIVERY_LEGS WLG,
18165: mtl_item_locations_kfv mil,
18166: wsh_Delivery_details wdd2
18167: WHERE
18168: HP.party_id = cust_acct.party_id