DBA Data[Home] [Help]

APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on HR_ORGANIZATION_INFORMATION

Line 462: hr_organization_information hoi,

458: OR wnd.delivery_type = 'CONSOLIDATION')
459: AND wfct.name = 'SUMMARY'
460: AND wfct.freight_cost_type_code = 'FTESUMMARY') ifc,
461: isc_dbi_tmp_trip_stops its,
462: hr_organization_information hoi,
463: gl_sets_of_books gsb
464: WHERE wdl.delivery_id = wnd.delivery_id
465: AND wnd.initial_pickup_date >= g_global_start_date
466: AND nvl(wnd.shipping_control, 'NA') <> 'SUPPLIER'

Line 945: hr_organization_information hoi,

941: OR wnd.delivery_type = 'CONSOLIDATION')
942: AND wfct.name = 'SUMMARY'
943: AND wfct.freight_cost_type_code = 'FTESUMMARY') ifc,
944: isc_dbi_tmp_trip_stops its,
945: hr_organization_information hoi,
946: gl_sets_of_books gsb
947: WHERE wdl.delivery_id = wnd.delivery_id
948: AND wnd.initial_pickup_date >= g_global_start_date
949: AND nvl(wnd.shipping_control, 'NA') <> 'SUPPLIER'