APPS.RLM_SHIP_DELIVERY_PATTERN_SV SQL Statements

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

Line: 831

         SELECT count(*)
         INTO  v_Exists
         FROM  rlm_ship_delivery_codes
         WHERE ship_delivery_rule_name = x_SdpCode;

Line: 1030

   SELECT ship_delivery_rule_name
   INTO v_SdpCode
   FROM RLM_CUST_ITEM_TERMS_ALL
   WHERE customer_item_id = x_CustomerItemId
   AND   ship_from_org_id = x_ShipFromOrgId
   AND   address_id = x_ShipToAddressId;

Line: 1039

      SELECT ship_delivery_rule_name
      INTO v_SdpCode
      FROM RLM_CUST_SHIPTO_TERMS_ALL
      WHERE ship_from_org_id = x_ShipFromOrgId
      AND address_id = x_ShipToAddressId;

Line: 1088

   SELECT   sunday_percent/100,
            monday_percent/100,
            tuesday_percent/100,
            wednesday_percent/100,
            thursday_percent/100,
            friday_percent/100,
            saturday_percent/100
   INTO     v_DailyPercent(g_SundayDOW),
            v_DailyPercent(g_MondayDOW),
            v_DailyPercent(g_TuesdayDOW),
            v_DailyPercent(g_WednesdayDOW),
            v_DailyPercent(g_ThursdayDOW),
            v_DailyPercent(g_FridayDOW),
            v_DailyPercent(g_SaturdayDOW)
   FROM     rlm_ship_delivery_codes
   WHERE    ship_delivery_rule_name = x_RuleName;

Line: 1167

   SELECT ship_method
   INTO   v_ShipMethod
   FROM   RLM_CUST_ITEM_TERMS_ALL
   WHERE  ship_from_org_id = x_ShipFromOrgId AND
          address_id = x_ShipToAddressId AND
          customer_item_id = x_CustomerItemId;

Line: 1176

      SELECT ship_method
      INTO v_ShipMethod
      FROM RLM_CUST_SHIPTO_TERMS_ALL
      WHERE ship_from_org_id = x_ShipFromOrgId AND
            address_id = x_ShipToAddressId;

Line: 1226

   SELECT intransit_time, time_uom_code
   INTO v_LeadTime.Time, v_LeadTime.Uom
   FROM mtl_interorg_ship_methods
   WHERE from_organization_id = x_ShipFromOrgId AND
         to_organization_id =  x_ShipToAddressId AND
         ship_method = x_ShipMethod;

Line: 2347

	SELECT	ETG.TP_GROUP_CODE
	INTO	x_tp_group_code
	FROM	ECE_TP_GROUP ETG,
		ECE_TP_HEADERS ETH,
		HZ_CUST_ACCT_SITES ACCT_SITE
	WHERE	ETG.TP_GROUP_ID = ETH.TP_GROUP_ID
	and	ETH.TP_HEADER_ID = ACCT_SITE.TP_HEADER_ID
	and	ACCT_SITE.CUST_ACCOUNT_ID = x_Input.ShiptoCustomerId
	and	ACCT_SITE.CUST_ACCT_SITE_ID = x_Input.ShipToAddressId;

Line: 2373

     SELECT 	ece_tp_location_code
     INTO   	x_ship_to_ece_locn_code
     FROM   	HZ_CUST_ACCT_SITES		 ACCT_SITE
     WHERE  	ACCT_SITE.CUST_ACCT_SITE_ID = x_Input.ShipToAddressId;

Line: 2394

     SELECT 	ece_tp_location_code
     INTO  	x_bill_to_ece_locn_code
     FROM   	HZ_CUST_ACCT_SITES		 ACCT_SITE
     WHERE  	ACCT_SITE.CUST_ACCT_SITE_ID = x_Input.BillToAddressId;

Line: 2416

     SELECT 	ece_tp_location_code
     INTO  	x_inter_ship_to_ece_locn_code
     FROM   	HZ_CUST_ACCT_SITES		ACCT_SITE
     WHERE  	ACCT_SITE.CUST_ACCT_SITE_ID = x_Input.IntShipToAddressId;

Line: 2440

	SELECT	account_number
	INTO	x_customer_number
	FROM	HZ_CUST_ACCOUNTS CUST_ACCT
	WHERE	CUST_ACCT.CUST_ACCOUNT_ID = x_Input.CustomerId;