Skip to content

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

TABLE: JL.JL_BR_AP_TAX_CALENDAR_LINES

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


JL_BR_AP_TAX_CALENDAR_LINES stores the lines for each withholding tax calendar header, related to the withholding tax, that allows the user to have a specific due date to pay the withholding tax.
This table corresponds to the TAX_CALENDAR_LINES block of the Tax Calendars window.
.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JL_BR_AP_TAX_CALENDAR_LINE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_CALENDAR_ID
Columns
Name Datatype Length Mandatory Comments
TAX_CALENDAR_ID NUMBER
Yes Withholding Tax Calendar Line Identifier
TAX_CALENDAR_NAME VARCHAR2 (25) Yes Withholding Tax Calendar Name
START_DATE DATE
Yes Withholding Start Date
END_DATE DATE
Yes Withholding End Date
DUE_DATE DATE
Yes Withholding Invoice Due Date
ACTIVE VARCHAR2 (1) Yes Flag that indicates if this withholding tax line is active
INACTIVE_DATE DATE

Inactive Date
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT TAX_CALENDAR_ID
,      TAX_CALENDAR_NAME
,      START_DATE
,      END_DATE
,      DUE_DATE
,      ACTIVE
,      INACTIVE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM JL.JL_BR_AP_TAX_CALENDAR_LINES;

Dependencies

[top of page]

JL.JL_BR_AP_TAX_CALENDAR_LINES does not reference any database object

JL.JL_BR_AP_TAX_CALENDAR_LINES is referenced by following:

SchemaJL
ViewJL_BR_AP_TAX_CALENDAR_LINES#