Search Results branch_code




Overview
Explore in AI Chat

Overview

PAY_JP_SS_BANK_BRANCH_BRANCH_LOV_V (documented as APPS.PAY_JP_SS_BANK_BRANCH_LOV_V) is a database view owned by the APPS schema within the Oracle E-Business Suite Payroll (PAY) product. The ETRM metadata classifies the object as a VIEW with a status of VALID, and its description states explicitly that it is used only for the Japanese localisation. Its role is to serve as a list of values (LOV) source for bank branch selection in Japanese payroll and related self-service flows. Rather than presenting all bank branch records, the view pre-filters the underlying branch data to return only enabled branches, thereby providing a clean, current selection set for forms, concurrent processes, and reporting integrations that must resolve a bank branch name or code.

Underlying Base Objects

The view is defined over a single documented base object, PAY_JP_BANK_BRANCHES, referenced in the metadata as a SYNONYM. The view text selects from this table and applies a filter of ENABLED_FLAG = 'Y', ensuring that disabled or obsolete bank branch records are excluded from the LOV. The view also applies an ORDER BY BANK_CODE, BRANCH_CODE, so results are returned in a deterministic bank-then-branch sequence suitable for LOV presentation and reporting output. Column-level transformations are limited to NVL logic on the two date columns, defaulting the active start date to 01010001 and the end date to 31124712 in DDMMYYYY format when the stored values are null. This effectively treats a missing start date as the earliest possible date and a missing end date as a far-future date, so the branch is always considered in range unless explicitly constrained.

Key Columns

  • BANK_CODE — The code identifying the bank; also the primary sort key and part of the branch's composite identity.
  • BRANCH_CODE — The code identifying the specific branch within the bank; the secondary sort key.
  • BRANCH_NAME — The display name of the branch, and the attribute most commonly matched when users search for "branch_name" in LOV and reporting contexts.
  • BRANCH_NAME_KANA — The phonetic (kana) rendering of the branch name, supporting Japanese-language search and sorting.
  • START_DATE_ACTIVE — The date the branch becomes active, defaulted to 01010001 when null.
  • END_DATE_ACTIVE — The date the branch ceases to be active, defaulted to 31124712 when null.

Common Use Cases and Queries

The principal use case is populating a branch LOV in Japanese payroll forms and setup pages, where an end user selects a bank and then a branch from the filtered, ordered list. It is equally useful for ad-hoc reporting that requires a valid, enabled branch reference, for integration extracts that must map a branch name back to its code, and for validation routines that confirm a supplied bank/branch combination exists. A typical query selecting the branch name and its codes is:

SELECT bank_code, branch_code, branch_name, branch_name_kana
FROM apps.pay_jp_ss_bank_branch_lov_v
WHERE bank_code = :p_bank_code
ORDER BY branch_code;

A lookup by name, reflecting a common "branch_name" search, can be expressed as:

SELECT branch_name, branch_code
FROM apps.pay_jp_ss_bank_branch_lov_v
WHERE UPPER(branch_name) LIKE UPPER(:p_search) || '%';

Because the view is restricted to ENABLED_FLAG = 'Y' rows, consumers benefit from an implicit currency filter and need not reproduce that predicate. All access should be performed through the APPS synonym, consistent with standard EBS practice, and the object should be understood as a Japanese localisation artifact rather than a globally applicable payroll view.

  • View: PAY_JP_SS_BANK_BRANCH_LOV_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PAY.PAY_JP_SS_BANK_BRANCH_LOV_V,  object_name:PAY_JP_SS_BANK_BRANCH_LOV_V,  status:VALID,  product: PAY - Payroll ,  description: This view is only used for the Japanese localisation. ,  implementation_dba_data: APPS.PAY_JP_SS_BANK_BRANCH_LOV_V , 

  • View: PAY_JP_SS_BANK_BRANCH_LOV_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PAY.PAY_JP_SS_BANK_BRANCH_LOV_V,  object_name:PAY_JP_SS_BANK_BRANCH_LOV_V,  status:VALID,  product: PAY - Payroll ,  description: This view is only used for the Japanese localisation. ,  implementation_dba_data: APPS.PAY_JP_SS_BANK_BRANCH_LOV_V , 

  • View: PAY_ZA_EXTERNAL_ACCOUNTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PAY.PAY_ZA_EXTERNAL_ACCOUNTS_V,  object_name:PAY_ZA_EXTERNAL_ACCOUNTS_V,  status:VALID,  product: PAY - Payroll ,  description: List of payments with their associated bank details. ,  implementation_dba_data: APPS.PAY_ZA_EXTERNAL_ACCOUNTS_V , 

  • View: PAY_ZA_EXTERNAL_ACCOUNTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PAY.PAY_ZA_EXTERNAL_ACCOUNTS_V,  object_name:PAY_ZA_EXTERNAL_ACCOUNTS_V,  status:VALID,  product: PAY - Payroll ,  description: List of payments with their associated bank details. ,  implementation_dba_data: APPS.PAY_ZA_EXTERNAL_ACCOUNTS_V , 

  • Table: PAY_ZA_BRANCH_CDV_DETAILS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ZA_BRANCH_CDV_DETAILS,  object_name:PAY_ZA_BRANCH_CDV_DETAILS,  status:VALID,  product: PAY - Payroll ,  description: PAY_ZA_BRANCH_CDV_DETAILS stores Bank and Branch information used to verify Bank account numbers. ,  implementation_dba_data: HR.PAY_ZA_BRANCH_CDV_DETAILS , 

  • Table: PAY_ZA_TEMP_BRANCH_DETAILS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ZA_TEMP_BRANCH_DETAILS,  object_name:PAY_ZA_TEMP_BRANCH_DETAILS,  status:VALID,  product: PAY - Payroll ,  description: PAY_ZA_TEMP_BRANCH_DETAILS is a temporary table that holds Bank and Branch information used to verify Bank account numbers, used in the population of PAY_ZA_BRANCH_CDV_DETAILS. ,  implementation_dba_data: HR.PAY_ZA_TEMP_BRANCH_DETAILS , 

  • Table: PAY_ZA_BRANCH_CDV_DETAILS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ZA_BRANCH_CDV_DETAILS,  object_name:PAY_ZA_BRANCH_CDV_DETAILS,  status:VALID,  product: PAY - Payroll ,  description: PAY_ZA_BRANCH_CDV_DETAILS stores Bank and Branch information used to verify Bank account numbers. ,  implementation_dba_data: HR.PAY_ZA_BRANCH_CDV_DETAILS , 

  • Table: PAY_ZA_TEMP_BRANCH_DETAILS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_ZA_TEMP_BRANCH_DETAILS,  object_name:PAY_ZA_TEMP_BRANCH_DETAILS,  status:VALID,  product: PAY - Payroll ,  description: PAY_ZA_TEMP_BRANCH_DETAILS is a temporary table that holds Bank and Branch information used to verify Bank account numbers, used in the population of PAY_ZA_BRANCH_CDV_DETAILS. ,  implementation_dba_data: HR.PAY_ZA_TEMP_BRANCH_DETAILS , 

  • Table: PAY_BANK_BRANCHES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_BANK_BRANCHES,  object_name:PAY_BANK_BRANCHES,  status:VALID,  product: PAY - Payroll ,  description: Stores bank branch information to enable entry of bank account details with the correct branch information (e.g. GB bank, sort code, branch). ,  implementation_dba_data: HR.PAY_BANK_BRANCHES , 

  • Table: PAY_BANK_BRANCHES 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_BANK_BRANCHES,  object_name:PAY_BANK_BRANCHES,  status:VALID,  product: PAY - Payroll ,  description: Stores bank branch information to enable entry of bank account details with the correct branch information (e.g. GB bank, sort code, branch). ,  implementation_dba_data: HR.PAY_BANK_BRANCHES , 

  • Table: PAY_JP_BANK_BRANCHES 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_JP_BANK_BRANCHES,  object_name:PAY_JP_BANK_BRANCHES,  status:VALID,  product: PAY - Payroll ,  description: This table is used for Japanese bank branch information. ,  implementation_dba_data: HR.PAY_JP_BANK_BRANCHES , 

  • Table: PAY_JP_BANK_BRANCHES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:PAY.PAY_JP_BANK_BRANCHES,  object_name:PAY_JP_BANK_BRANCHES,  status:VALID,  product: PAY - Payroll ,  description: This table is used for Japanese bank branch information. ,  implementation_dba_data: HR.PAY_JP_BANK_BRANCHES , 

  • View: PAY_ZA_BANK_ADDRESS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PAY.PAY_ZA_BANK_ADDRESS_V,  object_name:PAY_ZA_BANK_ADDRESS_V,  status:VALID,  product: PAY - Payroll ,  description: PAY_ZA_BANK_ADDRESS_V is a view based on Bank / Branch details and CDV weighting factors. ,  implementation_dba_data: APPS.PAY_ZA_BANK_ADDRESS_V , 

  • View: PAY_ZA_BANK_ADDRESS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PAY.PAY_ZA_BANK_ADDRESS_V,  object_name:PAY_ZA_BANK_ADDRESS_V,  status:VALID,  product: PAY - Payroll ,  description: PAY_ZA_BANK_ADDRESS_V is a view based on Bank / Branch details and CDV weighting factors. ,  implementation_dba_data: APPS.PAY_ZA_BANK_ADDRESS_V ,