Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JL_BR_AR_REC_MET_ACCTS_EXT_V

Object Details
Object Name: JL_BR_AR_REC_MET_ACCTS_EXT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJL.JL_BR_AR_REC_MET_ACCTS_EXT_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
BANK_ACCT_USE_ID NUMBER (15) Yes
RECEIPT_METHOD_ID NUMBER (15) Yes
BANK_CHARGES_CCID NUMBER

COLL_ENDORSEMENT_CCID NUMBER

BILLS_COLLECTION_CCID NUMBER

OTHER_CREDITS_CCID NUMBER

FACTORING_DOCS_CCID NUMBER

PORTFOLIO_CODE NUMBER

MIN_DOCUMENT_AMOUNT NUMBER

MAX_DOCUMENT_AMOUNT NUMBER

MIN_REMITTANCE_AMOUNT NUMBER

MAX_REMITTANCE_AMOUNT NUMBER

BANK_INSTRUCTION_CODE1 NUMBER

BANK_INSTRUCTION_CODE2 NUMBER

BANK_CHARGE_AMOUNT NUMBER

FACTORING_RATE NUMBER

FACTORING_RATE_PERIOD NUMBER

BATCH_SOURCE_ID NUMBER

CALCULATED_INTEREST_CCID NUMBER

INTEREST_WRITEOFF_CCID NUMBER

FACTORING_INTEREST_CCID NUMBER

ABATEMENT_WRITEOFF_CCID NUMBER (15)
ABATEMENT_REVENUE_CCID NUMBER (15)
INTEREST_REVENUE_CCID NUMBER (15)
CALCULATED_INTEREST_RECTRX_ID NUMBER (15)
INTEREST_WRITEOFF_RECTRX_ID NUMBER (15)
INTEREST_REVENUE_RECTRX_ID NUMBER (15)
ABATEMENT_WRITEOFF_RECTRX_ID NUMBER (15)
ABATEMENT_REVENUE_RECTRX_ID NUMBER (15)
WRITEOFF_PERC_TOLERANCE NUMBER

WRITEOFF_AMOUNT_TOLERANCE NUMBER

GL_DATE_BANK_RETURN VARCHAR2 (15)
DISC_ENDORSEMENT_CCID NUMBER (15)
DISCOUNTED_BILLS_CCID NUMBER (15)
BILLS_DISCOUNT_CCID NUMBER (15)
FACTORING_CHARGES_CCID NUMBER (15)
GL_DATE_BANK_RETURN_DSP VARCHAR2 (80)
FLOATING NUMBER (3)
ORG_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
RECEIPT_METHOD_NAME_DSP VARCHAR2 (30) Yes
RECEIPT_CLASS_NAME_DSP VARCHAR2 (30) Yes
COLLECTION_METHOD VARCHAR2 (150)
COLLECTION_METHOD_DSP VARCHAR2 (80)
BANK_PARTY_ID NUMBER (15) Yes
BANK_NAME_DSP VARCHAR2 (360) Yes
BANK_NUMBER_DSP VARCHAR2 (30)
BANK_BRANCH_NAME_DSP VARCHAR2 (360) Yes
BANK_NUM_DSP VARCHAR2 (30)
BANK_BRANCH_ID_DSP NUMBER (15) Yes
BANK_ACCOUNT_NUM_DSP VARCHAR2 (30)
CALC_INTEREST_RECTRX_ID_DSP VARCHAR2 (50)
INT_WRITEOFF_RECTRX_ID_DSP VARCHAR2 (50)
INT_REVENUE_RECTRX_ID_DSP VARCHAR2 (50)
ABATE_WRITEOFF_RECTRX_ID_DSP VARCHAR2 (50)
ABATE_REVENUE_RECTRX_ID_DSP VARCHAR2 (50)
BANK_INSTRUCTION_TYPE1 VARCHAR2 (30)
BANK_INSTRUCTION_CODE1_DSP VARCHAR2 (240)
BANK_INSTRUCTION_TYPE2 VARCHAR2 (30)
BANK_INSTRUCTION_CODE2_DSP VARCHAR2 (240)
BATCH_SOURCE_DSP VARCHAR2 (50)
MAX_COLLECTION_DOCS NUMBER

OCC_FILE_FORMAT_PGM_ID NUMBER (15)
OCC_REP_FORMAT_PGM_ID NUMBER (15)
FACTOR_FORMAT_PGM_ID NUMBER (15)
FACTOR_REMITTANCE_MEDIA VARCHAR2 (30)
COLL_FORMAT_PGM_ID NUMBER (15)
COLL_REMITTANCE_MEDIA VARCHAR2 (30)
COLL_FORMAT_PROGRAM_DSP VARCHAR2 (30) Yes
FACTOR_FORMAT_PROGRAM_DSP VARCHAR2 (30) Yes
OCC_REP_FORMAT_PROGRAM_DSP VARCHAR2 (30) Yes
OCC_FILE_FORMAT_PROGRAM_DSP VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      BANK_ACCT_USE_ID
,      RECEIPT_METHOD_ID
,      BANK_CHARGES_CCID
,      COLL_ENDORSEMENT_CCID
,      BILLS_COLLECTION_CCID
,      OTHER_CREDITS_CCID
,      FACTORING_DOCS_CCID
,      PORTFOLIO_CODE
,      MIN_DOCUMENT_AMOUNT
,      MAX_DOCUMENT_AMOUNT
,      MIN_REMITTANCE_AMOUNT
,      MAX_REMITTANCE_AMOUNT
,      BANK_INSTRUCTION_CODE1
,      BANK_INSTRUCTION_CODE2
,      BANK_CHARGE_AMOUNT
,      FACTORING_RATE
,      FACTORING_RATE_PERIOD
,      BATCH_SOURCE_ID
,      CALCULATED_INTEREST_CCID
,      INTEREST_WRITEOFF_CCID
,      FACTORING_INTEREST_CCID
,      ABATEMENT_WRITEOFF_CCID
,      ABATEMENT_REVENUE_CCID
,      INTEREST_REVENUE_CCID
,      CALCULATED_INTEREST_RECTRX_ID
,      INTEREST_WRITEOFF_RECTRX_ID
,      INTEREST_REVENUE_RECTRX_ID
,      ABATEMENT_WRITEOFF_RECTRX_ID
,      ABATEMENT_REVENUE_RECTRX_ID
,      WRITEOFF_PERC_TOLERANCE
,      WRITEOFF_AMOUNT_TOLERANCE
,      GL_DATE_BANK_RETURN
,      DISC_ENDORSEMENT_CCID
,      DISCOUNTED_BILLS_CCID
,      BILLS_DISCOUNT_CCID
,      FACTORING_CHARGES_CCID
,      GL_DATE_BANK_RETURN_DSP
,      FLOATING
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECEIPT_METHOD_NAME_DSP
,      RECEIPT_CLASS_NAME_DSP
,      COLLECTION_METHOD
,      COLLECTION_METHOD_DSP
,      BANK_PARTY_ID
,      BANK_NAME_DSP
,      BANK_NUMBER_DSP
,      BANK_BRANCH_NAME_DSP
,      BANK_NUM_DSP
,      BANK_BRANCH_ID_DSP
,      BANK_ACCOUNT_NUM_DSP
,      CALC_INTEREST_RECTRX_ID_DSP
,      INT_WRITEOFF_RECTRX_ID_DSP
,      INT_REVENUE_RECTRX_ID_DSP
,      ABATE_WRITEOFF_RECTRX_ID_DSP
,      ABATE_REVENUE_RECTRX_ID_DSP
,      BANK_INSTRUCTION_TYPE1
,      BANK_INSTRUCTION_CODE1_DSP
,      BANK_INSTRUCTION_TYPE2
,      BANK_INSTRUCTION_CODE2_DSP
,      BATCH_SOURCE_DSP
,      MAX_COLLECTION_DOCS
,      OCC_FILE_FORMAT_PGM_ID
,      OCC_REP_FORMAT_PGM_ID
,      FACTOR_FORMAT_PGM_ID
,      FACTOR_REMITTANCE_MEDIA
,      COLL_FORMAT_PGM_ID
,      COLL_REMITTANCE_MEDIA
,      COLL_FORMAT_PROGRAM_DSP
,      FACTOR_FORMAT_PROGRAM_DSP
,      OCC_REP_FORMAT_PROGRAM_DSP
,      OCC_FILE_FORMAT_PROGRAM_DSP
FROM APPS.JL_BR_AR_REC_MET_ACCTS_EXT_V;

Dependencies

[top of page]

APPS.JL_BR_AR_REC_MET_ACCTS_EXT_V references the following:

SchemaAPPS
SynonymAP_PAYMENT_PROGRAMS
SynonymAR_BATCH_SOURCES
SynonymAR_RECEIPT_CLASSES
SynonymAR_RECEIPT_METHODS
SynonymAR_RECEIVABLES_TRX_ALL
SynonymCE_BANK_ACCOUNTS
SynonymCE_BANK_ACCT_USES_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
SynonymHZ_ORGANIZATION_PROFILES
SynonymHZ_PARTIES
SynonymJL_BR_AR_BANK_INSTRUCTIONS
SynonymJL_BR_AR_REC_MET_ACCTS_EXT_ALL

APPS.JL_BR_AR_REC_MET_ACCTS_EXT_V is not referenced by any database object