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.WSH_MDC_SRS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 148


    l_sel_del_attr              select_del_flags_rec_type;

Line: 210


        SELECT COUNT(DELIVERY_LEG_ID)
        FROM WSH_DELIVERY_LEGS
        WHERE DELIVERY_ID = p_delivery_id;

Line: 216


        SELECT WTS.TRIP_ID
        FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL
        WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
        AND WDL.DELIVERY_ID = c_delivery_id;

Line: 224


        SELECT CARRIER_MANIFESTING_FLAG
        FROM   MTL_PARAMETERS
        WHERE  ORGANIZATION_ID = c_org_id;

Line: 385


        WSH_UTIL_CORE.PrintMsg('No deliveries selected for consolidation');

Line: 388


        WSH_UTIL_CORE.PrintMsg('The following deliveries are selected for consolidation');

Line: 442


                    l_delivery_tab.delete(i);

Line: 443


                    l_delivery_addnl_attr_tab.delete(i);

Line: 456


                    l_delivery_tab.delete(i);

Line: 457


                    l_delivery_addnl_attr_tab.delete(i);

Line: 524


                            fnd_msg_pub.delete_msg();

Line: 532


                            l_delivery_tab.delete(i);

Line: 533


                            l_delivery_addnl_attr_tab.delete(i);

Line: 550


                            fnd_msg_pub.delete_msg();

Line: 557


                        l_delivery_tab.delete(i);

Line: 558


                        l_delivery_addnl_attr_tab.delete(i);

Line: 627


            fnd_msg_pub.delete_msg();

Line: 644


            fnd_msg_pub.delete_msg();

Line: 671


            l_delivery_tab.delete(l_failed_del_id);

Line: 672


            l_delivery_addnl_attr_tab.delete(l_failed_del_id);

Line: 771


        l_group_tab.DELETE;

Line: 842


                SELECT WSH_DELIVERY_GROUP_S.nextval INTO l_group_tab(l_group_index).group_id FROM DUAL;

Line: 947


            WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.PROCESS_CARRIER_SELECTION',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 950


        WSH_TRIPS_ACTIONS.PROCESS_CARRIER_SELECTION(
            p_init_msg_list    =>    l_init_msg_list,
            p_trip_id_tab       =>    l_trips_all,
            p_caller            =>    'FTE',
            x_msg_count         =>    l_msg_count,
            x_msg_data          =>    l_msg_data,
            x_return_status     =>    l_return_status);

Line: 960


        l_action_prms.action_code := 'SELECT-CARRIER';

Line: 993


            fnd_msg_pub.delete_msg();

Line: 1000


            WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIPS_ACTIONS.PROCESS_CARRIER_SELECTION');

Line: 1011


            fnd_msg_pub.delete_msg();

Line: 1083


            fnd_msg_pub.delete_msg();

Line: 1175


        x_sel_del_attr    OUT NOCOPY    select_del_flags_rec_type,
        x_return_status   OUT NOCOPY  VARCHAR2)
IS
    l_module_name           CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_BATCH_PARAMETERS';

Line: 1182


       SELECT
        ORGANIZATION_ID,
        CONSOL_GROUPING_RULE_ID,
        CONSOL_SHIP_TO_LOCATION_ID,
        SHIP_TO_OVERIDE_FLAG,
        DELIVERY_NAME_FROM,
        DELIVERY_NAME_TO,
        PICKUP_START_DAYS,
        PICKUP_END_DAYS,
        DROPOFF_START_DAYS,
        DROPOFF_END_DAYS,
        PR_BATCH_ID,
        CUSTOMER_ID,
        FOB_CODE,
        FREIGHT_TERMS_CODE,
        CARRIER_ID,
        MODE_OF_TRANSPORT,
        SERVICE_LEVEL,
        LOADING_SEQUENCE,
        INTMED_SHIP_TO_LOCATION_ID,
        ULTI_SHIP_TO_LOCATION_ID,
        ULTI_SHIP_TO_REGION,
        ULTI_SHIP_TO_ZIP_FROM,
        ULTI_SHIP_TO_ZIP_TO,
        ULTI_SHIP_TO_ZONE,
        INCL_STAGED_DEL_FLAG,
        INCL_DEL_ASG_TRIPS_FLAG,
        CR_TRIP_TO_ULTM_SHIP_TO,
        ROUTE_TRIPS_FLAG,
        RATE_TRIPS_FLAG,
        TRIP_NAME_PREFIX,
        MAX_TRIP_WEIGHT,
        MAX_TRIP_WEIGHT_UOM
    FROM    WSH_CONSOL_BATCHES
    WHERE    BATCH_ID = p_batch_id;

Line: 1296


        p_sel_del_attr              IN            select_del_flags_rec_type,
        x_delivery_tab              OUT NOCOPY    WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_tab_type,
        x_delivery_addnl_attr_tab   OUT NOCOPY    addnl_del_attr_tab_type,
        x_return_status             OUT NOCOPY           VARCHAR2)
IS
    l_delivery_rec          WSH_FTE_CONSTRAINT_FRAMEWORK.delivery_ccinfo_rec_type;

Line: 1304


    l_select_clause         varchar2(1000);

Line: 1363


    l_select_clause := 'SELECT WND.DELIVERY_ID, WND.NAME, WND.ORGANIZATION_ID, WND.STATUS_CODE, WND.PLANNED_FLAG, WND.INITIAL_PICKUP_DATE,';

Line: 1364


    l_select_clause := l_select_clause || ' WND.INITIAL_PICKUP_LOCATION_ID, WND.ULTIMATE_DROPOFF_LOCATION_ID, WND.ULTIMATE_DROPOFF_DATE,';

Line: 1365


    l_select_clause := l_select_clause || ' WND.CUSTOMER_ID, WND.INTMED_SHIP_TO_LOCATION_ID, WND.SHIP_METHOD_CODE, WND.DELIVERY_TYPE, WND.CARRIER_ID,';

Line: 1366


    l_select_clause := l_select_clause || ' WND.SERVICE_LEVEL, WND.MODE_OF_TRANSPORT, WND.SHIPMENT_DIRECTION, WND.PARTY_ID, WND.SHIPPING_CONTROL,';

Line: 1367


    l_select_clause := l_select_clause || ' WND.FOB_CODE, WND.FREIGHT_TERMS_CODE, WND.LOADING_SEQUENCE, NVL(WND.GROSS_WEIGHT,0) GROSS_WEIGHT, WND.WEIGHT_UOM_CODE, WND.IGNORE_FOR_PLANNING ';

Line: 1375


    l_where_clause := l_where_clause || ' AND EXISTS( SELECT NULL FROM WSH_DELIVERY_ASSIGNMENTS INNER WHERE INNER.DELIVERY_ID = WND.DELIVERY_ID) ';

Line: 1407


	    SELECT INSTR(p_sel_del_attr.delivery_name_from,'%') INTO l_wc_index FROM DUAL;

Line: 1550


        l_where_clause := l_where_clause || ' AND WND.ULTIMATE_DROPOFF_LOCATION_ID IN (SELECT LOCATION_ID FROM WSH_REGION_LOCATIONS  WHERE REGION_ID = :p_region_id)';

Line: 1580


        l_where_clause := l_where_clause || ' AND WND.ULTIMATE_DROPOFF_LOCATION_ID IN (SELECT LOCATION_ID FROM WSH_REGION_LOCATIONS WHERE REGION_ID IN (SELECT REGION_ID FROM  WSH_ZONE_REGIONS WHERE PARENT_REGION_ID = :p_zone_id))';

Line: 1587


        l_where_clause := l_where_clause || ' AND NOT EXISTS ( SELECT 1 FROM WSH_DELIVERY_LEGS WHERE DELIVERY_ID = WND.DELIVERY_ID AND ROWNUM < 2)';

Line: 1594


        l_where_clause := l_where_clause || ' AND NOT EXISTS ( SELECT 1 FROM WSH_DELIVERY_ASSIGNMENTS WDA, WSH_DELIVERY_DETAILS WDD WHERE WDA.DELIVERY_ID = WND.DELIVERY_ID';

Line: 1604


    l_where_clause := l_where_clause || ' AND NOT EXISTS (SELECT 1 FROM WSH_DELIVERY_ASSIGNMENTS WDA, WSH_NEW_DELIVERIES CONSOL';

Line: 1607


    l_query := l_select_clause||l_from_clause||l_where_clause;

Line: 1802


            fnd_msg_pub.delete_msg();

Line: 1872


            x_delivery_tab.delete(l_delivery_id);

Line: 1873


            x_delivery_addnl_attr_tab.delete(l_delivery_id);

Line: 1923


    SELECT
        SHIP_FROM_FLAG,
        CUSTOMER_FLAG,
        INTMED_SHIP_TO_FLAG,
        CARRIER_FLAG,
        MODE_OF_TRANSPORT_FLAG,
        SERVICE_LEVEL_FLAG,
        FOB_FLAG,
        FREIGHT_TERMS_FLAG,
        LOADING_SEQUENCE_FLAG,
        SHIP_TO_CODE,
        SHIP_TO_COUNTRY_FLAG,
        SHIP_TO_STATE_FLAG,
        SHIP_TO_CITY_FLAG,
        SHIP_TO_POSTAL_CODE_FLAG,
        SHIP_TO_ZONE
    FROM    WSH_CONSOL_GROUPING_RULES
    WHERE    CONSOL_GROUPING_RULE_ID = p_rule_id;

Line: 1943


    SELECT RULE_NAME
    FROM WSH_CONSOL_GROUPING_RULES
    WHERE CONSOL_GROUPING_RULE_ID = p_rule_id;

Line: 2022


    SELECT COUNTRY, STATE, CITY, POSTAL_CODE
    FROM WSH_LOCATIONS
    WHERE WSH_LOCATION_ID = c_location_id;

Line: 2030


    SELECT REGION_ID
    FROM WSH_REGION_LOCATIONS
    WHERE LOCATION_ID = c_location_id
    AND REGION_ID IN (SELECT REGION_ID
                      FROM WSH_ZONE_REGIONS
                      WHERE PARENT_REGION_ID = c_zone_region_id);

Line: 2321


        l_consol_tab.DELETE;

Line: 2350


                    x_delivery_tab.DELETE(l_d_id);

Line: 2351


                    x_delivery_addnl_attr_tab.DELETE(l_d_id);

Line: 2481


                    fnd_msg_pub.delete_msg();

Line: 2495


                    fnd_msg_pub.delete_msg();

Line: 2603


        SELECT PLANNED_ARRIVAL_DATE
        FROM WSH_TRIP_STOPS
        WHERE TRIP_ID = c_trip_id
        ORDER BY STOP_SEQUENCE_NUMBER DESC;

Line: 2660


		l_trip_info_tab.DELETE;

Line: 2665


                    WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 2668


                WSH_TRIPS_GRP.Create_Update_Trip(
                    p_api_version_number => l_api_version_number,
                    p_init_msg_list      => l_init_msg_list,
                    p_commit         => l_commit,
                    x_return_status      => l_return_status,
                    x_msg_count      => l_msg_count,
                    x_msg_data       => l_msg_data,
                    p_trip_info_tab      => l_trip_info_tab,
                    p_in_rec         => l_trip_in_rec,
                    x_out_tab        => l_trip_out_rec_tab);

Line: 2688


                    WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIPS_GRP.Create_Update_Trip');

Line: 2697


                    fnd_msg_pub.delete_msg();

Line: 2711


                    fnd_msg_pub.delete_msg();

Line: 2723


                   l_trip_in_rec.action_code := 'UPDATE';

Line: 2732


                       WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.Create_Update_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 2736


                   WSH_TRIPS_GRP.Create_Update_Trip(
                            p_api_version_number => l_api_version_number,
                            p_init_msg_list      => l_init_msg_list,
                            p_commit             => l_commit,
                            x_return_status      => l_return_status,
                            x_msg_count          => l_msg_count,
                            x_msg_data           => l_msg_data,
                            p_trip_info_tab      => l_trip_info_tab,
                            p_in_rec             => l_trip_in_rec,
                            x_out_tab            => l_trip_out_rec_tab);

Line: 2756


                       WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIPS_GRP.Create_Update_Trip');

Line: 2765


                       fnd_msg_pub.delete_msg();

Line: 2779


                        fnd_msg_pub.delete_msg();

Line: 2833


                    fnd_msg_pub.delete_msg();

Line: 2847


                    fnd_msg_pub.delete_msg();

Line: 2865


                    WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 2868


                WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
                    p_api_version_number    => l_api_version_number,
                    p_init_msg_list         => l_init_msg_list,
                    p_commit                => l_commit,
                    p_in_rec                => l_stop_in_rec,
                    p_rec_attr_tab          => l_pickup_rec_attr_tab,
                    x_stop_out_tab          => l_pickup_stop_out_tab,
                    x_return_status         => l_return_status,
                    x_msg_count             => l_msg_count,
                    x_msg_data              => l_msg_data,
                    x_stop_wt_vol_out_tab   => l_stop_wt_vol_out_tab);

Line: 2888


                    WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

Line: 2897


                    fnd_msg_pub.delete_msg();

Line: 2911


                    fnd_msg_pub.delete_msg();

Line: 2922


                    WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP',WSH_DEBUG_SV.C_PROC_LEVEL);

Line: 2926


                WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
                    p_api_version_number    => l_api_version_number,
                    p_init_msg_list         => l_init_msg_list,
                    p_commit                => l_commit,
                    p_in_rec                => l_stop_in_rec,
                    p_rec_attr_tab          => l_dropoff_rec_attr_tab,
                    x_stop_out_tab          => l_dropoff_stop_out_tab,
                    x_return_status         => l_return_status,
                    x_msg_count             => l_msg_count,
                    x_msg_data              => l_msg_data,
                    x_stop_wt_vol_out_tab   => l_stop_wt_vol_out_tab);

Line: 2946


                    WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');

Line: 2955


                    fnd_msg_pub.delete_msg();

Line: 2969


                    fnd_msg_pub.delete_msg();

Line: 3046


                    fnd_msg_pub.delete_msg();

Line: 3060


                    fnd_msg_pub.delete_msg();