[Home] [Help]
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
5358: AND wwl.delivery_detail_id = wdd.delivery_detail_id
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
7215: AND wwl.delivery_detail_id = wdd.delivery_detail_id
9464: FROM wms_waveplan_tasks_temp wwtt,
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
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,
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
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,
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
9520: FROM mtl_material_transactions mmt,
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
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
13106:
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
15525: AND wwl.delivery_detail_id = wdd.delivery_detail_id
15526: and wwl.organization_id = wdd.organization_id
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
15548: AND wwl.delivery_detail_id = wdd.delivery_detail_id
15549: and wwl.organization_id = wdd.organization_id
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
15574: AND wwl.delivery_detail_id = wdd.delivery_detail_id
15575: and wwl.organization_id = wdd.organization_id
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
15605: AND wwl.delivery_detail_id = wdd.delivery_detail_id
15606: and wwl.organization_id = wdd.organization_id
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
15622: AND wda.delivery_id = wnd.delivery_id(+)
15623: AND wnd.delivery_id = wdl.delivery_id(+)
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
15648: AND wwl.delivery_detail_id = wdd.delivery_detail_id
15649: and wwl.organization_id = wdd.organization_id
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
15666: and wwl.organization_id = wdd.organization_id
15667: AND wdd.delivery_detail_id = wda.delivery_detail_id
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
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(+)
18159: WSH_CARRIERS WC,
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