[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

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#