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

VIEW: JL.JL_BR_AR_BORDEROS_ALL#

Object Details
Object Name: JL_BR_AR_BORDEROS_ALL#
Object Type: VIEW
Owner: JL
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BORDERO_ID NUMBER
Yes
SELECTION_CONTROL_ID NUMBER
Yes
BANK_ACCOUNT_ID NUMBER

BORDERO_STATUS VARCHAR2 (30) Yes
SEQUENTIAL_NUMBER_GENERATION NUMBER

BORDERO_TYPE VARCHAR2 (30)
TOTAL_COUNT NUMBER

TOTAL_AMOUNT NUMBER

SELECTION_DATE DATE

REMITTANCE_DATE DATE

REFUSED_DATE DATE

CANCELLATION_DATE DATE

COLLECTION_DATE DATE

WRITE_OFF_DATE DATE

DATE_IN_RECEIPT DATE

RECEIVED_DATE DATE

OUTPUT_PROGRAM_ID NUMBER (15)
SELECT_ACCOUNT_ID NUMBER

OUTPUT_FORMAT VARCHAR2 (30)
ORG_ID NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
BANK_ACCT_USE_ID NUMBER (15) Yes
Query Text

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


SELECT BORDERO_ID
,      SELECTION_CONTROL_ID
,      BANK_ACCOUNT_ID
,      BORDERO_STATUS
,      SEQUENTIAL_NUMBER_GENERATION
,      BORDERO_TYPE
,      TOTAL_COUNT
,      TOTAL_AMOUNT
,      SELECTION_DATE
,      REMITTANCE_DATE
,      REFUSED_DATE
,      CANCELLATION_DATE
,      COLLECTION_DATE
,      WRITE_OFF_DATE
,      DATE_IN_RECEIPT
,      RECEIVED_DATE
,      OUTPUT_PROGRAM_ID
,      SELECT_ACCOUNT_ID
,      OUTPUT_FORMAT
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BANK_ACCT_USE_ID
FROM JL.JL_BR_AR_BORDEROS_ALL#;

Dependencies

[top of page]

JL.JL_BR_AR_BORDEROS_ALL# references the following:

SchemaJL
TableJL_BR_AR_BORDEROS_ALL
JL.JL_BR_AR_BORDEROS_ALL# is referenced by following:

SchemaAPPS
SynonymJL_BR_AR_BORDEROS
SynonymJL_BR_AR_BORDEROS_ALL