1 Reply Latest reply on Oct 8, 2017 2:36 PM by 3203003

    Primary key columns seeded tables in r12.2

    3203003

      Hi Gurus,

       

      Looking for the Primary Key column for the below tables in R12.2

       

       

        

      S.NoTables
      1bom_structure_types_b
      2csf_debrief_headers
      3cst_item_costs
      4fa_deprn_periods
      5fnd_concurrent_programs_tl
      6fnd_document_entities_tl
      7fnd_id_flex_segments
      8fnd_id_flex_structures
      9fnd_id_flexs
      10fnd_lookup_values
      11fnd_profile_options
      12fnd_responsibility
      13fnd_responsibility_tl
      14gl_code_combinations
      15gl_je_sources_tl
      16gl_ledgers
      17gl_period_sets
      18gl_period_types
      19hz_cust_accounts
      20hz_parties
      21ibe_dsp_lgl_phys_map
      22mtl_default_category_sets
      23mtl_item_loc_defaults
      24mtl_item_revisions_b
      25mtl_item_revisions_tl
      26mtl_item_sub_defaults
      27mtl_serial_numbers
      28mtl_system_items_b
      29mtl_units_of_measure_tl
      30mtl_uom_class_conversions
      31pa_budget_types
      32pa_class_categories
      33pa_class_codes
      34pa_project_types_all
      35pa_projects_all
      36po_control_functions
      37ra_batch_sources_all
      38zx_jurisdictions_b
      39

      zx_regimes_b

        • 1. Re: Primary key columns seeded tables in r12.2
          3203003

          Got this information .

           

           

             

          S.NoTablesPrimary Key Column
          1bom_structure_types_bSTRUCTURE_TYPE_ID
          2csf_debrief_headersDEBRIEF_HEADER_ID
          3cst_item_costsINVENTORY_ITEM_ID,COST_TYPE_ID,ORGANIZATION_ID
          4fa_deprn_periodsBOOK_TYPE_CODE,PERIOD_COUNTER
          5fnd_concurrent_programs_tlAPPLICATION_ID,CONCURRENT_PROGRAM_ID,LANGUAGE
          6fnd_document_entities_tlDOCUMENT_ENTITY_ID,LANGUAGE
          7fnd_id_flex_segmentsAPPLICATION_ID,ID_FLEX_CODE,ID_FLEX_NUM,APPLICATION_COLUMN_NAME
          8fnd_id_flex_structuresAPPLICATION_ID,ID_FLEX_CODE,ID_FLEX_NUM
          9fnd_id_flexsAPPLICATION_ID,ID_FLEX_CODE
          10fnd_lookup_valuesLOOKUP_TYPE,LANGUAGE,LOOKUP_CODE,SECURITY_GROUP_ID,VIEW_APPLICATION_ID
          11fnd_profile_optionsAPPLICATION_ID,PROFILE_OPTION_ID
          12fnd_responsibilityAPPLICATION_ID,RESPONSIBILITY_ID
          13fnd_responsibility_tlAPPLICATION_ID,RESPONSIBILITY_ID,LANGUAGE
          14gl_code_combinationsCODE_COMBINATION_ID
          15gl_je_sources_tlJE_SOURCE_NAME,LANGUAGE
          16gl_ledgersLEDGER_ID
          17gl_period_setsPERIOD_SET_ID
          18gl_period_typesPERIOD_TYPE_ID
          19hz_cust_accountsCUST_ACCOUNT_ID
          20hz_partiesPARTY_ID
          21ibe_dsp_lgl_phys_mapLGL_PHYS_MAP_ID
          22mtl_default_category_setsFUNCTIONAL_AREA_ID,CATEGORY_SET_ID
          23mtl_item_loc_defaultsINVENTORY_ITEM_ID,ORGANIZATION_ID,LOCATOR_ID,DEFAULT_TYPE,SUBINVENTORY_CODE
          24mtl_item_revisions_bINVENTORY_ITEM_ID,ORGANIZATION_ID,REVISION_ID
          25mtl_item_revisions_tlINVENTORY_ITEM_ID,ORGANIZATION_ID,REVISION_ID,LANGUAGE
          26mtl_item_sub_defaultsINVENTORY_ITEM_ID,ORGANIZATION_ID,SUBINVENTORY_CODE,DEFAULT_TYPE
          27mtl_serial_numbersSERIAL_NUMBER,INVENTORY_ITEM_ID,CURRENT_ORGANIZATION_ID
          28mtl_system_items_bINVENTORY_ITEM_ID,ORGANIZATION_ID
          29mtl_units_of_measure_tlUNIT_OF_MEASURE,LANGUAGE
          30mtl_uom_class_conversionsINVENTORY_ITEM_ID,FROM_UNIT_OF_MEASURE,TO_UNIT_OF_MEASURE
          31pa_budget_typesBUDGET_TYPE_CODE
          32pa_class_categoriesCLASS_CATEGORY
          33pa_class_codesCLASS_CODE,CLASS_CATEGORY
          34pa_project_types_allPROJECT_TYPE,ORG_ID
          35pa_projects_allPROJECT_ID
          36po_control_functionsCONTROL_FUNCTION_ID
          37ra_batch_sources_allBATCH_SOURCE_ID
          38zx_jurisdictions_bTAX_REGIME_CODE,TAX,TAX_JURISDICTION_CODE
          39zx_regimes_bTAX_REGIME_CODE

           

           

          regards

          Abdul