APPS.WSH_EXTERNAL_INTERFACE_SV SQL Statements

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

Line: 47

select	carrier_manifesting_flag,
	distributed_organization_flag
from	mtl_parameters
where	organization_id= p_organization_id;

Line: 53

select  distinct wc.manifesting_enabled_flag
from    wsh_delivery_details wdd,
        wsh_carrier_services wcs,
        wsh_carriers wc,
        wsh_new_deliveries wnd,
        wsh_delivery_assignments_v wda
where   wdd.delivery_detail_id = p_delivery_detail_id
and     wdd.delivery_detail_id = wda.delivery_detail_id(+)
and     wda.delivery_id = wnd.delivery_id(+)
and     ( nvl(wnd.ship_method_code,wdd.ship_method_code) = wcs.ship_method_code
        or nvl(wnd.carrier_id,wdd.carrier_id) = wcs.carrier_id
        )
and     wcs.carrier_id  = wc.carrier_id;

Line: 68

select  distinct wc.manifesting_enabled_flag
from	wsh_new_deliveries wnd,
        wsh_carrier_services wcs,
        wsh_carriers wc
where   wnd.delivery_id = p_delivery_id
and     (  wnd.ship_method_code = wcs.ship_method_code
	or wnd.carrier_id = wcs.carrier_id
	)
and     wcs.carrier_id  = wc.carrier_id;

Line: 79

select  distinct wc.manifesting_enabled_flag
from    wsh_carrier_services wcs,
        wsh_carriers wc
where   wcs.carrier_id=p_carrier_id
and     wcs.carrier_id  = wc.carrier_id;

Line: 86

select  distinct wc.manifesting_enabled_flag
from    wsh_carrier_services wcs,
        wsh_carriers wc
where   wcs.ship_method_code = p_ship_method_code
and     wcs.carrier_id  = wc.carrier_id;

Line: 283

      SELECT Initial_Pickup_Location_ID,
	     ultimate_dropoff_location_id, 	--Notification change heali
             customer_id			--Notification change heali
      FROM   wsh_new_deliveries
      WHERE  Organization_ID = l_trading_partner_id
      AND    Name = l_name;

Line: 292

        SELECT  ui_location_code
        FROM    wsh_locations
        WHERE  wsh_location_id=p_location_id;

Line: 297

        SELECT HP.PARTY_NAME
        FROM   HZ_CUST_ACCOUNTS HCA, HZ_PARTIES HP
        WHERE  HP.PARTY_ID = HCA.PARTY_ID
        AND    HP.PARTY_ID = p_customer_id;

Line: 314

      wsh_update_history      EXCEPTION;

Line: 418

         SELECT WSH_DOCUMENT_NUMBER_S.NEXTVAL
         INTO   l_txn_hist_record.Document_Number
         FROM   dual;

Line: 564

         WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History ( l_txn_hist_record,
                                                                   l_txns_id,
                                                                   l_return_status );

Line: 574

            RAISE wsh_update_history;

Line: 623

      WHEN wsh_update_history THEN
         x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

Line: 626

          WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_history exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line: 627

          WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');

Line: 648

select	inventory_item_id
from	mtl_system_items_kfv
where	concatenated_segments = p_concatenated_segments
and	organization_id = p_organization_id;

Line: 719

SELECT  HL.LOCATION_ID,
	HCA.CUST_ACCOUNT_ID,
	HCSU.SITE_USE_ID
FROM	HZ_CUST_ACCOUNTS HCA,
	HZ_PARTIES HP,
        HZ_CUST_SITE_USES_ALL HCSU,
        HZ_CUST_ACCT_SITES_ALL HCAS,
--	ORG_ORGANIZATION_DEFINITIONS OOD,
        HZ_PARTY_SITES HPS,
        HZ_LOCATIONS HL
WHERE   HCSU.CUST_ACCT_SITE_ID          = HCAS.CUST_ACCT_SITE_ID
AND     HCAS.PARTY_SITE_ID              = HPS.PARTY_SITE_ID
AND     HCSU.SITE_USE_CODE              IN ( p_site_use_code, 'SHIP_TO')
AND     HCSU.STATUS                     = 'A'
--AND 	HCAS.ORG_ID			= HCSU.ORG_ID
--AND	HCSU.ORG_ID			= OOD.OPERATING_UNIT
--AND	OOD.ORGANIZATION_ID		= p_organization_id
AND     HPS.LOCATION_ID                 = HL.LOCATION_ID
AND     HCSU.LOCATION                   = p_location
AND	HCAS.CUST_ACCOUNT_ID	  	= HCA.CUST_ACCOUNT_ID
AND     HP.PARTY_ID			= HCA.PARTY_ID
AND    HCAS.ORG_ID            = NVL(p_org_id , HCAS.ORG_ID)
AND 	HP.PARTY_NAME			= p_customer_name
; --bmso

Line: 747

     SELECT HPS.LOCATION_ID,
             HCA.CUST_ACCOUNT_ID,
             HCSU.SITE_USE_ID
      FROM   HZ_CUST_SITE_USES_ALL HCSU,
             HZ_CUST_ACCT_SITES_ALL HCAS,
             HZ_PARTY_SITES HPS,
             HZ_CUST_ACCOUNTS HCA,
           HZ_CUST_ACCT_RELATE_ALL HCAR,
             HZ_PARTIES HP
      WHERE  HCSU.CUST_ACCT_SITE_ID = HCAS.CUST_ACCT_SITE_ID
      AND    HCAS.PARTY_SITE_ID     = HPS.PARTY_SITE_ID
      AND    HCAS.CUST_ACCOUNT_ID   = HCAR.CUST_ACCOUNT_ID
      AND    HCSU.SITE_USE_CODE     IN (p_site_use_code, 'SHIP_TO')
      AND    HCSU.STATUS            = 'A'
      AND    HCAS.STATUS            = 'A'
      AND    HCA.STATUS             = 'A'
      AND    HCSU.location          =  p_location
      AND    HCA.CUST_ACCOUNT_ID    = HCAR.RELATED_CUST_ACCOUNT_ID
      AND    HCAR.SHIP_TO_FLAG      = 'Y'
      AND    NVL(HCAS.ORG_ID, -999) = NVL(HCSU.ORG_ID , -999)
      AND    HCAS.ORG_ID            = NVL(p_org_id , HCAS.ORG_ID)
      AND     HP.PARTY_ID    = HCA.PARTY_ID
      AND     HP.PARTY_NAME  = p_customer_name;