eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.JE_NO_INVEST_LINES

Object Details

Object Name:	JE_NO_INVEST_LINES
Object Type:	TABLE
Owner:	AP
FND Design Data:	JE.JE_NO_INVEST_LINES
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JE_NO_INVEST_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROGRAM_APPLICATION_ID PROGRAM_ID

Columns

Name	Datatype	Length	Mandatory
INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes
ACCOUNTING_DATE	DATE		Yes
ACCRUAL_POSTED_FLAG	VARCHAR2	(1)
ASSETS_ADDITION_FLAG	VARCHAR2	(1)
ASSETS_TRACKING_FLAG	VARCHAR2	(1)
CASH_POSTED_FLAG	VARCHAR2	(1)
DISTRIBUTION_LINE_NUMBER	NUMBER	(15)
DIST_CODE_COMBINATION_ID	NUMBER	(15)
INVOICE_ID	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)
PERIOD_NAME	VARCHAR2	(15)
SET_OF_BOOKS_ID	NUMBER	(15)
ACCTS_PAY_CODE_COMBINATION_ID	NUMBER	(15)
AMOUNT	NUMBER
BASE_AMOUNT	NUMBER
BASE_INVOICE_PRICE_VARIANCE	NUMBER
BATCH_ID	NUMBER	(15)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
DESCRIPTION	VARCHAR2	(240)
EXCHANGE_RATE_VARIANCE	NUMBER
FINAL_MATCH_FLAG	VARCHAR2	(1)
INCOME_TAX_REGION	VARCHAR2	(10)
INVOICE_PRICE_VARIANCE	NUMBER
LAST_UPDATE_LOGIN	NUMBER
MATCH_STATUS_FLAG	VARCHAR2	(1)
POSTED_FLAG	VARCHAR2	(1)
PO_DISTRIBUTION_ID	NUMBER	(15)
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
QUANTITY_INVOICED	NUMBER
RATE_VAR_CODE_COMBINATION_ID	NUMBER	(15)
REQUEST_ID	NUMBER	(15)
REVERSAL_FLAG	VARCHAR2	(1)
TYPE_1099	VARCHAR2	(10)
UNIT_PRICE	NUMBER
VAT_CODE	VARCHAR2	(15)
AMOUNT_ENCUMBERED	VARCHAR2	(15)
BASE_AMOUNT_ENCUMBERED	NUMBER
ENCUMBERED_FLAG	VARCHAR2	(1)
EXCHANGE_DATE	DATE
EXCHANGE_RATE	NUMBER
EXCHANGE_RATE_TYPE	VARCHAR2	(30)
PRICE_ADJUSTMENT_FLAG	VARCHAR2	(1)
PRICE_VAR_CODE_COMBINATION_ID	NUMBER	(15)
QUANTITY_UNENCUMBERED	NUMBER
STAT_AMOUNT	NUMBER
AMOUNT_TO_POST	NUMBER
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE_CATEGORY	VARCHAR2	(150)
BASE_AMOUNT_TO_POST	NUMBER
CASH_JE_BATCH_ID	NUMBER	(15)
EXPENDITURE_ITEM_DATE	DATE
EXPENDITURE_ORGANIZATION_ID	NUMBER	(15)
EXPENDITURE_TYPE	VARCHAR2	(30)
JE_BATCH_ID	NUMBER	(15)
PARENT_INVOICE_ID	NUMBER	(15)
PA_ADDITION_FLAG	VARCHAR2	(1)
PA_QUANTITY	NUMBER	(22)
POSTED_AMOUNT	NUMBER
POSTED_BASE_AMOUNT	NUMBER
PREPAY_AMOUNT_REMAINING	NUMBER
PROJECT_ACCOUNTING_CONTEXT	VARCHAR2	(30)
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
USSGL_TRX_CODE_CONTEXT	VARCHAR2	(30)
EARLIEST_SETTLEMENT_DATE	DATE
REQ_DISTRIBUTION_ID	NUMBER	(15)
QUANTITY_VARIANCE	NUMBER
BASE_QUANTITY_VARIANCE	NUMBER
PACKET_ID	NUMBER	(15)
W_SESSIONID	NUMBER
W_ENTRYID	NUMBER
ACCOUNTING_EVENT_ID	NUMBER	(15)
PREPAY_DISTRIBUTION_ID	NUMBER	(15)
TAX_CODE_ID	NUMBER	(15)
AWARD_ID	NUMBER	(15)
GMS_BURDENABLE_RAW_COST	NUMBER
DIST_MATCH_TYPE	VARCHAR2	(30)
RCV_TRANSACTION_ID	NUMBER	(15)
PARENT_REVERSAL_ID	NUMBER	(15)
MATCHED_UOM_LOOKUP_CODE	VARCHAR2	(30)
AR_INVOICE_ID	NUMBER	(15)
AR_INVOICE_LINE_NUM	NUMBER	(15)
PA_IC_PROCESSED_FLAG	VARCHAR2	(1)
TAX_RECOVERY_RATE	NUMBER
TAX_RECOVERY_OVERRIDE_FLAG	VARCHAR2	(1)
TAX_RECOVERABLE_FLAG	VARCHAR2	(1)
TAX_CODE_OVERRIDE_FLAG	VARCHAR2	(80)
MERCHANT_DOCUMENT_NUMBER	VARCHAR2	(80)
MERCHANT_NAME	VARCHAR2	(80)
MERCHANT_REFERENCE	VARCHAR2	(240)
MERCHANT_TAX_REG_NUMBER	VARCHAR2	(80)
MERCHANT_TAXPAYER_ID	VARCHAR2	(80)
COUNTRY_OF_SUPPLY	VARCHAR2	(5)
PA_CC_AR_INVOICE_ID	NUMBER	(15)
PA_CC_AR_INVOICE_LINE_NUM	NUMBER	(15)
PA_CC_PROCESSED_CODE	VARCHAR2	(1)
CREDIT_CARD_TRX_ID	NUMBER	(15)

Query Text

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


SELECT INVOICE_DISTRIBUTION_ID
,      ACCOUNTING_DATE
,      ACCRUAL_POSTED_FLAG
,      ASSETS_ADDITION_FLAG
,      ASSETS_TRACKING_FLAG
,      CASH_POSTED_FLAG
,      DISTRIBUTION_LINE_NUMBER
,      DIST_CODE_COMBINATION_ID
,      INVOICE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LINE_TYPE_LOOKUP_CODE
,      PERIOD_NAME
,      SET_OF_BOOKS_ID
,      ACCTS_PAY_CODE_COMBINATION_ID
,      AMOUNT
,      BASE_AMOUNT
,      BASE_INVOICE_PRICE_VARIANCE
,      BATCH_ID
,      CREATED_BY
,      CREATION_DATE
,      DESCRIPTION
,      EXCHANGE_RATE_VARIANCE
,      FINAL_MATCH_FLAG
,      INCOME_TAX_REGION
,      INVOICE_PRICE_VARIANCE
,      LAST_UPDATE_LOGIN
,      MATCH_STATUS_FLAG
,      POSTED_FLAG
,      PO_DISTRIBUTION_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      QUANTITY_INVOICED
,      RATE_VAR_CODE_COMBINATION_ID
,      REQUEST_ID
,      REVERSAL_FLAG
,      TYPE_1099
,      UNIT_PRICE
,      VAT_CODE
,      AMOUNT_ENCUMBERED
,      BASE_AMOUNT_ENCUMBERED
,      ENCUMBERED_FLAG
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      PRICE_ADJUSTMENT_FLAG
,      PRICE_VAR_CODE_COMBINATION_ID
,      QUANTITY_UNENCUMBERED
,      STAT_AMOUNT
,      AMOUNT_TO_POST
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      BASE_AMOUNT_TO_POST
,      CASH_JE_BATCH_ID
,      EXPENDITURE_ITEM_DATE
,      EXPENDITURE_ORGANIZATION_ID
,      EXPENDITURE_TYPE
,      JE_BATCH_ID
,      PARENT_INVOICE_ID
,      PA_ADDITION_FLAG
,      PA_QUANTITY
,      POSTED_AMOUNT
,      POSTED_BASE_AMOUNT
,      PREPAY_AMOUNT_REMAINING
,      PROJECT_ACCOUNTING_CONTEXT
,      PROJECT_ID
,      TASK_ID
,      USSGL_TRANSACTION_CODE
,      USSGL_TRX_CODE_CONTEXT
,      EARLIEST_SETTLEMENT_DATE
,      REQ_DISTRIBUTION_ID
,      QUANTITY_VARIANCE
,      BASE_QUANTITY_VARIANCE
,      PACKET_ID
,      W_SESSIONID
,      W_ENTRYID
,      ACCOUNTING_EVENT_ID
,      PREPAY_DISTRIBUTION_ID
,      TAX_CODE_ID
,      AWARD_ID
,      GMS_BURDENABLE_RAW_COST
,      DIST_MATCH_TYPE
,      RCV_TRANSACTION_ID
,      PARENT_REVERSAL_ID
,      MATCHED_UOM_LOOKUP_CODE
,      AR_INVOICE_ID
,      AR_INVOICE_LINE_NUM
,      PA_IC_PROCESSED_FLAG
,      TAX_RECOVERY_RATE
,      TAX_RECOVERY_OVERRIDE_FLAG
,      TAX_RECOVERABLE_FLAG
,      TAX_CODE_OVERRIDE_FLAG
,      MERCHANT_DOCUMENT_NUMBER
,      MERCHANT_NAME
,      MERCHANT_REFERENCE
,      MERCHANT_TAX_REG_NUMBER
,      MERCHANT_TAXPAYER_ID
,      COUNTRY_OF_SUPPLY
,      PA_CC_AR_INVOICE_ID
,      PA_CC_AR_INVOICE_LINE_NUM
,      PA_CC_PROCESSED_CODE
,      CREDIT_CARD_TRX_ID
FROM AP.JE_NO_INVEST_LINES;

Dependencies

[top of page]

AP.JE_NO_INVEST_LINES does not reference any database object

AP.JE_NO_INVEST_LINES is referenced by following:

AP: JE_NO_INVEST_LINES#