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

TABLE: AP.AP_REPORTING_ENTITY_LINES_ALL

Object Details
Object Name: AP_REPORTING_ENTITY_LINES_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_REPORTING_ENTITY_LINES_ALL
Subobject Name:
Status: VALID


AP_REPORTING_ENTITY_LINES_ALL holds the line information for
the tax reporting entities you define. Each tax reporting
entity must have at least one line that contains the balancing
segment value for the organization for which you perform your
1099 reporting.
.
If you define more than one organization for your company or
agency, you can define tax reporting entities to handle your
multi-organization 1099 reporting. You use different balancing
segment values to represent the different organizations in your
company or organization.
.
You can define a reporting entity with a single balancing
segment line for each organization or you can
define a reporting entity with multiple lines to combine
1099 reporting for your organizations. For multi-organization
reporting entities, you define a different balancing segment value for
each line; however, you cannot assign the same balancing segment value
to more than one reporting entity.
.
This table corresponds to the Balancing Segment Values
region of the Reporting Entity window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_REPORTING_ENTITY_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBALANCING_SEGMENT_VALUE
ColumnORG_ID
Columns
Name Datatype Length Mandatory Comments
BALANCING_SEGMENT_VALUE VARCHAR2 (25) Yes Balancing segment value for reporting entity Accounting Flexfield(s)
TAX_ENTITY_ID NUMBER (15) Yes Reporting entity identifier
DESCRIPTION VARCHAR2 (80)
Description of balancing segment value
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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 (foreign key to FND_USER.USER_ID).
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT BALANCING_SEGMENT_VALUE
,      TAX_ENTITY_ID
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORG_ID
FROM AP.AP_REPORTING_ENTITY_LINES_ALL;

Dependencies

[top of page]

AP.AP_REPORTING_ENTITY_LINES_ALL does not reference any database object

AP.AP_REPORTING_ENTITY_LINES_ALL is referenced by following:

SchemaAPPS
SynonymAP_REPORTING_ENTITY_LINES
SynonymAP_REPORTING_ENTITY_LINES_ALL