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

TABLE: JL.JL_BR_CUSTOMER_TRX_EXTS

Object Details
Object Name: JL_BR_CUSTOMER_TRX_EXTS
Object Type: TABLE
Owner: JL
FND Design Data: TableJL.JL_BR_CUSTOMER_TRX_EXTS
Subobject Name:
Status: VALID


JL_BR_CUSTOMER_TRX_EXTS table is an extension table to RA_CUSTOMER_TRX_ALL table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_BR_CUSTOMER_TRX_EXTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUSTOMER_TRX_ID
Columns
Name Datatype Length Mandatory Comments
CUSTOMER_TRX_ID NUMBER (15) Yes Invoice Identifier
LEGAL_PROCESS_CODE VARCHAR2 (150)
Legal Process or Act Id
LEGAL_PROCESS_SOURCE_IND VARCHAR2 (1)
Legal Process Source Indicator
VEHICLE_PLATE_STATE_CODE VARCHAR2 (2)
Vehicle Plate State Code
VEHICLE_ANTT_INSCRIPTION VARCHAR2 (30)
Vehicle ANTT Inscription
TOWING_VEH_PLATE_NUMBER VARCHAR2 (30)
Towing Vehicle Plate Number
TOWING_VEH_PLATE_STATE_CODE VARCHAR2 (2)
Towing Vehicle Plate State Code
TOWING_VEH_ANTT_INSCRIPTION VARCHAR2 (30)
Towing Vehicle ANTT Inscription
SEAL_NUMBER VARCHAR2 (150)
Seal Number
ELECTRONIC_INV_WEB_ADDRESS VARCHAR2 (2000)
Electronic Invoice Web Address
ELECTRONIC_INV_STATUS VARCHAR2 (1)
Electronic Invoice Status
ELECTRONIC_INV_ACCESS_KEY VARCHAR2 (150)
Electronic Invoice Access Key
LAST_UPDATE_DATE DATE
Yes Standard who column - date when this row was updated
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row
CREATION_DATE DATE
Yes Standard who column - date when this row was created
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row
WAGON_CODE VARCHAR2 (30)
Wagon Code
FERRY_CODE VARCHAR2 (30)
Ferry Code
ELECTRONIC_INV_ACCESS_KEY_ID NUMBER (15)
Electronic Invoice Access Key Numerical Code
TOWING_VEH_PLATE_NUMBER2 VARCHAR2 (30)
Towing Vehicle Plate Number 2
TOWING_VEH_PLATE_STATE_CODE2 VARCHAR2 (2)
Towing Vehicle Plate State Code 2
TOWING_VEH_PLATE_NUMBER3 VARCHAR2 (30)
Towing Vehicle Plate Number 3
TOWING_VEH_PLATE_STATE_CODE3 VARCHAR2 (2)
Towing Vehicle Plate State Code 3
TOWING_VEH_PLATE_NUMBER4 VARCHAR2 (30)
Towing Vehicle Plate Number 4
TOWING_VEH_PLATE_STATE_CODE4 VARCHAR2 (2)
Towing Vehicle Plate State Code 4
TOWING_VEH_PLATE_NUMBER5 VARCHAR2 (30)
Towing Vehicle Plate Number 5
TOWING_VEH_PLATE_STATE_CODE5 VARCHAR2 (2)
Towing Vehicle Plate State Code 5
SRV_EXEC_DATE DATE

Service Execution Date
ELECTRONIC_INV_PROTOCOL#1 VARCHAR2 (60)
Electronic Invoice Protocol
Query Text

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


SELECT CUSTOMER_TRX_ID
,      LEGAL_PROCESS_CODE
,      LEGAL_PROCESS_SOURCE_IND
,      VEHICLE_PLATE_STATE_CODE
,      VEHICLE_ANTT_INSCRIPTION
,      TOWING_VEH_PLATE_NUMBER
,      TOWING_VEH_PLATE_STATE_CODE
,      TOWING_VEH_ANTT_INSCRIPTION
,      SEAL_NUMBER
,      ELECTRONIC_INV_WEB_ADDRESS
,      ELECTRONIC_INV_STATUS
,      ELECTRONIC_INV_ACCESS_KEY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      WAGON_CODE
,      FERRY_CODE
,      ELECTRONIC_INV_ACCESS_KEY_ID
,      TOWING_VEH_PLATE_NUMBER2
,      TOWING_VEH_PLATE_STATE_CODE2
,      TOWING_VEH_PLATE_NUMBER3
,      TOWING_VEH_PLATE_STATE_CODE3
,      TOWING_VEH_PLATE_NUMBER4
,      TOWING_VEH_PLATE_STATE_CODE4
,      TOWING_VEH_PLATE_NUMBER5
,      TOWING_VEH_PLATE_STATE_CODE5
,      SRV_EXEC_DATE
,      ELECTRONIC_INV_PROTOCOL#1
FROM JL.JL_BR_CUSTOMER_TRX_EXTS;

Dependencies

[top of page]

JL.JL_BR_CUSTOMER_TRX_EXTS does not reference any database object

JL.JL_BR_CUSTOMER_TRX_EXTS is referenced by following:

SchemaJL
ViewJL_BR_CUSTOMER_TRX_EXTS#