APPS.ZX_TCM_EXT_SERVICES_PUB SQL Statements

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

Line: 51

  SELECT tax_status_code
  FROM   zx_sco_status
  WHERE  tax_regime_code     = p_tax_regime_code
  AND    tax                 = p_tax
  AND    default_status_flag  = 'Y'
  AND    p_date >= default_flg_effective_from
  AND   (p_date <= default_flg_effective_to OR default_flg_effective_to IS NULL);

Line: 62

  SELECT tax_rate_code
  FROM   zx_sco_rates
  WHERE  tax_regime_code     = p_tax_regime_code
  AND    tax                 = p_tax
  AND    tax_status_code     = c_status_code
  AND    active_flag          = 'Y'
  AND    default_rate_flag    = 'Y'
  AND    p_date >= default_flg_effective_from
  AND    (p_date <= default_flg_effective_to OR default_flg_effective_to IS NULL);

Line: 280

  SELECT intended_use_default, product_categ_default, primary_inventory_category_set
  FROM   zx_fc_country_defaults
  WHERE  country_code   = p_country_code;

Line: 287

  SELECT intended_use_default
  FROM   zx_fc_country_defaults
  WHERE  country_code   = p_country_code;

Line: 293

  SELECT product_categ_default
  FROM   zx_fc_country_defaults
  WHERE  country_code   = p_country_code;

Line: 302

  SELECT tax_event_class_code, intrcmp_tx_evnt_cls_code
  FROM   zx_evnt_cls_mappings
  WHERE  application_id = p_application_id
  AND    entity_code = p_entity_code
  AND    event_class_code = p_event_class_code;

Line: 309

  SELECT  DEF_INTRCMP_TRX_BIZ_CATEGORY
  FROM  ZX_EVNT_CLS_OPTIONS
  WHERE event_class_code = p_event_class_code
  AND   FIRST_PTY_ORG_ID =  p_org_id;

Line: 317

   SELECT owner_table_code,owner_id_num
   FROM   zx_fc_types_b
   WHERE  classification_type_code ='INTENDED_USE';

Line: 322

   SELECT category_id
   FROM mtl_item_categories
   WHERE category_set_id = l_owner_id_num
   AND organization_id = p_org_id
   AND inventory_item_id = p_item_id;

Line: 329

   SELECT REPLACE (mtl.concatenated_segments,flex.concatenated_segment_delimiter,'')
   FROM MTL_CATEGORIES_B_KFV mtl,
        FND_ID_FLEX_STRUCTURES flex,
        MTL_CATEGORY_SETS_B mcs
   WHERE mtl.structure_id = mcs.structure_id
   AND   mcs.category_set_id = l_owner_id_num
   AND flex.ID_FLEX_NUM = mtl.STRUCTURE_ID
   AND flex.APPLICATION_ID = 401
   AND flex.ID_FLEX_CODE = 'MCAT'
   AND mtl.category_id = l_category_id;

Line: 342

   SELECT F.LOOKUP_CODE
   FROM FND_LOOKUPS F,
        MTL_SYSTEM_ITEMS_B I
   WHERE  F.LOOKUP_TYPE= 'ZX_PRODUCT_TYPE'
   AND I.INVENTORY_ITEM_ID = p_item_id
   AND I.ORGANIZATION_ID = p_org_id
   AND    F.LOOKUP_CODE =  DECODE (I.CONTRACT_ITEM_TYPE_CODE,
                   'SERVICE','SERVICES',
                   'WARRANTY','SERVICES',
                   'USAGE','SERVICES',
                   'SUBSCRIPTION','GOODS',
                   'GOODS');

Line: 357

  SELECT classification_code
  FROM   zx_fc_codes_denorm_b
  WHERE  classification_type_code = c_classification_type
  AND country_code   = p_country_code
  AND LANGUAGE = userenv('LANG');

Line: 364

  SELECT delimiter
  FROM   zx_fc_types_b
  WHERE  classification_type_code ='TRX_BUSINESS_CATEGORY';

Line: 941

  SELECT intended_use_default, product_categ_default, primary_inventory_category_set
  FROM   zx_fc_country_defaults
  WHERE  country_code   = p_country_code;

Line: 946

   SELECT category_id
   FROM mtl_item_categories
   WHERE category_set_id = l_category_set
   AND organization_id = p_org_id
   AND inventory_item_id = p_item_id;

Line: 953

   SELECT default_category_id
   FROM mtl_category_sets_b
   WHERE category_set_id = l_category_set;

Line: 958

   SELECT REPLACE (mtl.concatenated_segments,flex.concatenated_segment_delimiter,'')
   FROM MTL_CATEGORIES_B_KFV mtl,
        FND_ID_FLEX_STRUCTURES flex,
        MTL_CATEGORY_SETS_B mcs
   WHERE mtl.structure_id = mcs.structure_id
   AND   mcs.category_set_id = l_category_set
   AND flex.ID_FLEX_NUM = mtl.STRUCTURE_ID
   AND flex.APPLICATION_ID = 401
   AND flex.ID_FLEX_CODE = 'MCAT'
   AND mtl.category_id = l_category_id;

Line: 1256

 Select product_categ_default
 From ZX_FC_COUNTRY_DEFAULTS
 Where country_code = p_country_code;

Line: 1317

	       SELECT 	STATUS, DB_STATUS
	       INTO		l_status, l_db_status
	       FROM 	fnd_product_installations
	       WHERE 	APPLICATION_ID = '401';

Line: 1364

  Select NVL(reg.registration_number, PTP.rep_registration_number) registration_number
  From   zx_registrations reg
        ,zx_party_tax_profile ptp
  Where  ptp.party_id = p_party_id
  AND    ptp.party_type_code = p_party_type
  AND    ptp.party_tax_profile_id = reg.party_tax_profile_id
  AND    reg.default_registration_flag = 'Y'
  AND    l_effective_date >= effective_from
  AND    (l_effective_date <= effective_to OR effective_to IS NULL);

Line: 1375

  Select REP_REGISTRATION_NUMBER
  From   zx_party_tax_profile ptp
  Where  ptp.party_id = p_party_id
  AND    ptp.party_type_code = p_party_type;

Line: 1498

    SELECT distinct xle.legal_entity_id
    INTO   l_legal_entity_id
    from  zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle
    where tr.registration_number = p_registration_num
    and  tr.party_tax_profile_id = ptp.party_tax_profile_id
    and  ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
    and ptp.party_id = xle.party_id;

Line: 1608

      select TERRITORY_CODE into l_territory_code
      FROM   FND_TERRITORIES
      WHERE  TERRITORY_CODE = p_country_code;