[Home] [Help]
444: gsb.currency_code WH_CURRENCY_CODE,
445: wnd.delivery_type DELIVERY_TYPE,
446: wdl.parent_delivery_leg_id PARENT_DELIVERY_LEG_ID
447: FROM wsh_new_deliveries wnd,
448: wsh_delivery_legs wdl,
449: (select /*+ PARALLEL(wfc) */
450: wfc.delivery_leg_id, total_amount, wfc.currency_code, conversion_type_code, conversion_rate, conversion_date
451: from wsh_freight_costs wfc,wsh_freight_cost_types wfct,
452: wsh_new_deliveries wnd, wsh_delivery_legs wdl
448: wsh_delivery_legs wdl,
449: (select /*+ PARALLEL(wfc) */
450: wfc.delivery_leg_id, total_amount, wfc.currency_code, conversion_type_code, conversion_rate, conversion_date
451: from wsh_freight_costs wfc,wsh_freight_cost_types wfct,
452: wsh_new_deliveries wnd, wsh_delivery_legs wdl
453: where wfc.delivery_detail_id IS NULL
454: AND wfc.freight_cost_type_id = wfct.freight_cost_type_id
455: AND wnd.delivery_id = wdl.delivery_id
456: AND wdl.delivery_leg_id = wfc.delivery_leg_id
522: gl_sets_of_books gsb
523: WHERE fih.mode_of_transport = 'LTL'
524: AND fih.bill_status in ('APPROVED', 'IN_PROGRESS', 'PAID', 'PARTIALLY PAID', 'PARTIAL_PAID')
525: AND fih.bol = wdi.sequence_number
526: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
527: AND wdi.document_type = 'BOL'
528: AND wdi.entity_id = idl.delivery_leg_id
529: AND fih.org_id = aspa.org_id
530: AND aspa.set_of_books_id = gsb.set_of_books_id
799: WHERE delivery_leg_id IN (SELECT /*+ index(idl,ISC_DBI_DEL_LEGS_F_U1) use_nl( log, idl)*/ idl.delivery_leg_id
800: FROM isc_dbi_tmp_wts_log log,
801: isc_dbi_del_legs_f idl
802: WHERE (log.stop_id = idl.pick_up_stop_id or log.stop_id = idl.drop_off_stop_id)
803: AND NOT EXISTS (select '1' from wsh_delivery_legs wdl where wdl.delivery_leg_id = idl.delivery_leg_id));
804:
805: FII_UTIL.Stop_Timer;
806: FII_UTIL.Print_Timer('Deleted '||sql%rowcount||' delivery legs from base summary in');
807: COMMIT;
927: gsb.currency_code WH_CURRENCY_CODE,
928: wnd.delivery_type DELIVERY_TYPE,
929: wdl.parent_delivery_leg_id PARENT_DELIVERY_LEG_ID
930: FROM wsh_new_deliveries wnd,
931: wsh_delivery_legs wdl,
932: (select /*+ use_nl (wfct, wfc) */
933: wfc.delivery_leg_id, total_amount, wfc.currency_code, conversion_type_code, conversion_rate, conversion_date
934: from wsh_freight_costs wfc,wsh_freight_cost_types wfct,
935: wsh_new_deliveries wnd, wsh_delivery_legs wdl
931: wsh_delivery_legs wdl,
932: (select /*+ use_nl (wfct, wfc) */
933: wfc.delivery_leg_id, total_amount, wfc.currency_code, conversion_type_code, conversion_rate, conversion_date
934: from wsh_freight_costs wfc,wsh_freight_cost_types wfct,
935: wsh_new_deliveries wnd, wsh_delivery_legs wdl
936: where wfc.delivery_detail_id IS NULL
937: AND wfc.freight_cost_type_id = wfct.freight_cost_type_id
938: AND wnd.delivery_id = wdl.delivery_id
939: AND wdl.delivery_leg_id = wfc.delivery_leg_id
1116: WHERE log.invoice_header_id = fih.invoice_header_id
1117: AND fih.mode_of_transport = 'LTL'
1118: AND fih.bill_status in ('APPROVED', 'IN_PROGRESS', 'PAID', 'PARTIALLY PAID', 'PARTIAL_PAID')
1119: AND fih.bol = wdi.sequence_number
1120: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
1121: AND wdi.document_type = 'BOL'
1122: AND wdi.entity_id = idl.delivery_leg_id
1123: AND fih.org_id = aspa.org_id
1124: AND aspa.set_of_books_id = gsb.set_of_books_id