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: FII.FII_AR_TRX_DIST_F

Object Details

Object Name:	FII_AR_TRX_DIST_F
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_AR_TRX_DIST_F
Subobject Name:
Status:	VALID

The AR Revenue Fact table holds detailed invoice distribution line information. Each record represents a debit or credit account entry generated as part of creating an invoice.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_AR_TRX_DIST_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	INVOICE_PK
FII_AR_TRX_DIST_F_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	INVOICE_PK_KEY
FII_AR_TRX_DIST_F_N1	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	END_USER_CUSTOMER_FK_KEY
FII_AR_TRX_DIST_F_N10	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	CELL_ACTL_FK_KEY
FII_AR_TRX_DIST_F_N11	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	CELL_INIT_FK_KEY
FII_AR_TRX_DIST_F_N12	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	EVENT_OFFER_ACTL_FK_KEY
FII_AR_TRX_DIST_F_N13	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	EVENT_OFFER_INIT_FK_KEY
FII_AR_TRX_DIST_F_N14	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	EVENT_OFFER_REG_FK_KEY
FII_AR_TRX_DIST_F_N15	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_ACCT10_FK_KEY
FII_AR_TRX_DIST_F_N16	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_ACCT1_FK_KEY
FII_AR_TRX_DIST_F_N17	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_ACCT2_FK_KEY
FII_AR_TRX_DIST_F_N18	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_ACCT3_FK_KEY
FII_AR_TRX_DIST_F_N19	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_ACCT4_FK_KEY
FII_AR_TRX_DIST_F_N2	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	RESELLER_CUSTOMER_FK_KEY
FII_AR_TRX_DIST_F_N20	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_ACCT5_FK_KEY
FII_AR_TRX_DIST_F_N21	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_ACCT6_FK_KEY
FII_AR_TRX_DIST_F_N22	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_ACCT7_FK_KEY
FII_AR_TRX_DIST_F_N23	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_ACCT8_FK_KEY
FII_AR_TRX_DIST_F_N24	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_ACCT9_FK_KEY
FII_AR_TRX_DIST_F_N25	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	GL_DATE_FK_KEY
FII_AR_TRX_DIST_F_N26	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SET_OF_BOOKS_FK_KEY
FII_AR_TRX_DIST_F_N27	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
FII_AR_TRX_DIST_F_N28	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ITEM_FK_KEY
FII_AR_TRX_DIST_F_N29	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MARKET_SEGMENT_FK_KEY
FII_AR_TRX_DIST_F_N3	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	INVOICE_DATE_FK_KEY
FII_AR_TRX_DIST_F_N30	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MEDIA_ACTL_FK_KEY
FII_AR_TRX_DIST_F_N31	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	MEDIA_INIT_FK_KEY
FII_AR_TRX_DIST_F_N32	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	OFFER_ACTL_FK_KEY
FII_AR_TRX_DIST_F_N33	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	OFFER_INIT_FK_KEY
FII_AR_TRX_DIST_F_N34	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_FK_KEY
FII_AR_TRX_DIST_F_N35	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PARENT_ITEM_FK_KEY
FII_AR_TRX_DIST_F_N36	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PAYMENT_TERM_FK_KEY
FII_AR_TRX_DIST_F_N37	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PRIM_SALESREP_FK_KEY
FII_AR_TRX_DIST_F_N38	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	PROJECT_FK_KEY
FII_AR_TRX_DIST_F_N39	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SALESCHANNEL_FK_KEY
FII_AR_TRX_DIST_F_N4	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SALES_ORDER_DATE_FK_KEY
FII_AR_TRX_DIST_F_N40	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SALESREP_FK_KEY
FII_AR_TRX_DIST_F_N41	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SHIP_TO_CUSTOMER_FK_KEY
FII_AR_TRX_DIST_F_N42	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SHIP_TO_SITE_FK_KEY
FII_AR_TRX_DIST_F_N43	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SIC_CODE_FK_KEY
FII_AR_TRX_DIST_F_N44	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SOLD_TO_CUSTOMER_FK_KEY
FII_AR_TRX_DIST_F_N45	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SOLD_TO_SITE_FK_KEY
FII_AR_TRX_DIST_F_N46	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	SOURCE_LIST_FK_KEY
FII_AR_TRX_DIST_F_N47	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	TRANSACTION_CURRENCY_FK_KEY
FII_AR_TRX_DIST_F_N48	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	UOM_FK_KEY
FII_AR_TRX_DIST_F_N49	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	CAMPAIGN_STATUS_INIT_FK_KEY
FII_AR_TRX_DIST_F_N5	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	FUNCTIONAL_CURRENCY_FK_KEY
FII_AR_TRX_DIST_F_N50	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	CAMPAIGN_STATUS_ACTL_FK_KEY
FII_AR_TRX_DIST_F_N6	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	BILL_TO_CUSTOMER_FK_KEY
FII_AR_TRX_DIST_F_N7	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	BILL_TO_SITE_FK_KEY
FII_AR_TRX_DIST_F_N8	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	CAMPAIGN_ACTL_FK_KEY
FII_AR_TRX_DIST_F_N9	BITMAP	NONUNIQUE	APPS_TS_SUMMARY	CAMPAIGN_INIT_FK_KEY

Columns

Name	Datatype	Length	Comments
AGREEMENT_NAME	VARCHAR2	(30)	The agreement name for the order.
INVOICE_LINE_MEMO	VARCHAR2	(50)	Invoice line memo description.
SALES_ORDER_LINE_NUMBER	VARCHAR2	(30)	Sales order line number.
SALES_ORDER_SOURCE	VARCHAR2	(50)	The source of the sales order.
ORIGINAL_INVOICE_NUM	VARCHAR2	(30)	The original invoice number.
ORIGINAL_INVOICE_LINE_NUM	VARCHAR2	(10)	The original invoice line number.
INTERFACE_LINE_CONTEXT	VARCHAR2	(30)	Interface line context for the transaction line.
INVOICE_ID	VARCHAR2	(25)	A source system generated identifier for the transaction.
INVOICE_DIST_ID	VARCHAR2	(25)	A source system generated identifier for the transaction line distribution.
ORIGINAL_INVOICE_ID	VARCHAR2	(15)	A source system generated identifier for the transaction.
ORIGINAL_INVOICE_LINE_ID	VARCHAR2	(25)	A source system generated identifier for the transaction line.
END_USER_CUSTOMER_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level.
RESELLER_CUSTOMER_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Trading Partner dimension at the lowest level.
INVOICE_DATE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the time dimension at the lowest level.
SALES_ORDER_DATE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the time dimension at the lowest level.
INTERNAL_FLAG	VARCHAR2	(3)	For Internal purpose only.
AMT_B	NUMBER		Distribution amount in the functional currency.
AMT_G	NUMBER		Distribution amount in the warehouse global currency.
AMT_T	NUMBER		Distribution amount in the transaction currency.
FUNCTIONAL_CURRENCY_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the functional currency dimension at the lowest level.
BILL_TO_CUSTOMER_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level.
BILL_TO_SITE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the geography dimension at the lowest level.
CAMPAIGN_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the campaign dimension at the lowest level.
CAMPAIGN_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the campaign dimension at the lowest level.
ACCOUNT_ID	NUMBER		A source system generated identifier for the account.
CELL_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the target segment dimension at the lowest level.
CELL_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the target segment dimension at the lowest level.
INVOICE_LINE_ID	VARCHAR2	(25)	A source system generated identifier for the transaction line.
INVOICE_LINE_NUMBER	VARCHAR2	(10)	Line number for a specific transaction number.
EVENT_OFFER_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the event dimension at the lowest level.
EVENT_OFFER_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the event dimension at the lowest level.
EVENT_OFFER_REG_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the event dimension at the lowest level.
EXCHANGE_RATE	NUMBER		Currency exchange rate from the source system.
GL_ACCT10_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT1_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT2_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT3_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT4_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT5_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT6_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT7_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT8_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_ACCT9_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Accounting Flexfield dimension.
GL_DATE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Time dimension at the lowest level.
SET_OF_BOOKS_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the Set of Books dimension at the lowest level.
INSTANCE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the instance dimension at the lowest level.
ITEM_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the item dimension at the lowest level.
QTY_CREDITED	NUMBER		Quantity credited for this line.
INVOICE_LINE_QTY	NUMBER		Quantity invoiced for this line.
ORDER_LINE_QTY	NUMBER		Quantity ordered for this line.
MARKET_SEGMENT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the market segment dimension at the lowest level.
MEDIA_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the media channel dimension at the lowest level.
MEDIA_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the media channel dimension at the lowest level.
OFFER_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the offer dimension at the lowest level.
OFFER_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the offer dimension at the lowest level.
ORGANIZATION_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the organization dimension at the lowest level.
PARENT_ITEM_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the item dimension at the lowest level.
PAYMENT_TERM_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the payment terms dimension at the lowest level.
PRIM_SALESREP_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the person dimension at the lowest level.
PROJECT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the project dimension at the lowest level.
SALESCHANNEL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the sales channel dimension at the lowest level.
SALESREP_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the person dimension at the lowest level.
SHIP_TO_CUSTOMER_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level.
SHIP_TO_SITE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the geography dimension at the lowest level.
SIC_CODE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the standard industry code,SIC, dimension at the lowest level.
SOLD_TO_CUSTOMER_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level.
SOLD_TO_SITE_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the geography dimension at the lowest level.
SOURCE_LIST_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the source list dimension at the lowest level.
TRANSACTION_CURRENCY_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the transaction currency dimension at the lowest level.
UNIT_SELLING_PRICE	NUMBER		Selling price per unit for a transaction line.
SO_LINE_SELLING_PRICE	NUMBER		Selling price for sales order line.
UOM_FK_KEY	NUMBER		A foreign key generated by the warehouse system that points to the Unit of Measure dimension at the lowest level.
USER_FK1_KEY	NUMBER		A foreign key generated by the warehouse that points to the user defined foreign key.
USER_FK2_KEY	NUMBER		A foreign key generated by the warehouse that points to the user defined foreign key.
USER_FK3_KEY	NUMBER		A foreign key generated by the warehouse that points to the user defined foreign key.
USER_FK4_KEY	NUMBER		A foreign key generated by the warehouse that points to the user defined foreign key.
USER_FK5_KEY	NUMBER		A foreign key generated by the warehouse that points to the user defined foreign key.
USER_MEASURE1	NUMBER		User defined measure identifier.
USER_MEASURE2	NUMBER		User defined measure identifier.
USER_MEASURE3	NUMBER		User defined measure identifier.
USER_MEASURE4	NUMBER		User defined measure identifier.
USER_MEASURE5	NUMBER		User defined measure identifier.
CAMPAIGN_STATUS_INIT_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the campaign status dimension at the lowest level.
CAMPAIGN_STATUS_ACTL_FK_KEY	NUMBER		A foreign key generated by the warehouse that points to the campaign status dimension at the lowest level.
AGREEMENT_TYPE	VARCHAR2	(30)	Code used to group agreements.
INVOICE_SOURCE_NAME	VARCHAR2	(50)	Batch source name.
PROCESS_TYPE	VARCHAR2	(1)	The source of how invoices are entered into the receivables system.
EXCHANGE_RATE_TYPE	VARCHAR2	(30)	Currency exchange rate type from the source system.
INSTANCE	VARCHAR2	(40)	Instance identifier.
LINE_TYPE	VARCHAR2	(3)	The type of receivables invoice line. LIN, Regular Invoice Line. FRT,Freight Line. TAX,Tax Line. QTY, Quantity Line. ADJ, Adjustment Line.
ORDER_LINE_ID	VARCHAR2	(50)	A source system generated identifier for the sales order line.
SALES_ORDER_NUMBER	VARCHAR2	(30)	Sales order number.
INVOICE_REASON	VARCHAR2	(30)	Invoice reason.
INVOICE_PK	VARCHAR2	(120)	This is a unique key for the AR Revenue Fact. It is a concatenation of Oracle Applications Customer Transaction Line and GL Distribution table.
INVOICE_PK_KEY	NUMBER		This is the primary key for the AR Revenue Fact. This key is generated by the invoice unique key.
INVOICE_NUMBER	VARCHAR2	(30)	A document number that is created in Oracle Receivables.
USER_ATTRIBUTE1	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE10	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE11	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE12	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE13	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE14	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE15	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE2	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE3	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE4	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE5	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE6	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE7	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE8	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE9	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE16	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE17	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE18	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE19	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE20	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE21	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE22	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE23	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE24	VARCHAR2	(240)	User defined attribute value.
USER_ATTRIBUTE25	VARCHAR2	(240)	User defined attribute value.
EXCHANGE_DATE	DATE		Date of the currency exchange rate.
GL_DATE	DATE		General Ledger date.
INVOICE_DATE	DATE		Transaction date.
TRANSACTION_STATUS	VARCHAR2	(1)	Invoice or adjustment status. O, Open. C, Closed.
TRANSACTION_CLASS	VARCHAR2	(3)	A way to classify different types of transactions in Oracle Receivables. INV, Regular Invoice. CM, Credit Memo. DM, Debit Memo. CB, Charge Back. GUR, Guarentee. DEP, Deposit. ADJ, Adjustment. NULL, Unspecified Transaction Class.
GL_POSTED_DATE	DATE		Date posted to General Ledger.
CREATION_DATE	DATE		Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
ACCOUNT_TYPE	VARCHAR2	(4)	The account type as defined in the General Ledger. REV, Revenue. LIB, Liabilities. AST, Asset. EXP, Expenses. EQT, Owners Equity.
ACCOUNT_CLASS	VARCHAR2	(3)	The account class as defined in Account Receivables. REV, Revenue. FREIGHT. TAX. REC, Receivables. UNBILL, Unbilled Receivable. UNEARN, Unearned Revenue.
COMPANY_CC_ORG_FK_KEY	NUMBER		A foreign key generated by the warehouse for company_cost_center_org_id that points to the organization dimension at the lowest level.
SALESRESOURCE_FK_KEY	NUMBER		A foreign key generated by the warehouse for salesperson that points to the sales resource dimension at the lowest level.
PRIM_SALESRESOURCE_FK_KEY	NUMBER		A foreign key generated by the warehouse for salesperson that points to the sales resource dimension at the lowest level.

Query Text

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


SELECT AGREEMENT_NAME
,      INVOICE_LINE_MEMO
,      SALES_ORDER_LINE_NUMBER
,      SALES_ORDER_SOURCE
,      ORIGINAL_INVOICE_NUM
,      ORIGINAL_INVOICE_LINE_NUM
,      INTERFACE_LINE_CONTEXT
,      INVOICE_ID
,      INVOICE_DIST_ID
,      ORIGINAL_INVOICE_ID
,      ORIGINAL_INVOICE_LINE_ID
,      END_USER_CUSTOMER_FK_KEY
,      RESELLER_CUSTOMER_FK_KEY
,      INVOICE_DATE_FK_KEY
,      SALES_ORDER_DATE_FK_KEY
,      INTERNAL_FLAG
,      AMT_B
,      AMT_G
,      AMT_T
,      FUNCTIONAL_CURRENCY_FK_KEY
,      BILL_TO_CUSTOMER_FK_KEY
,      BILL_TO_SITE_FK_KEY
,      CAMPAIGN_ACTL_FK_KEY
,      CAMPAIGN_INIT_FK_KEY
,      ACCOUNT_ID
,      CELL_ACTL_FK_KEY
,      CELL_INIT_FK_KEY
,      INVOICE_LINE_ID
,      INVOICE_LINE_NUMBER
,      EVENT_OFFER_ACTL_FK_KEY
,      EVENT_OFFER_INIT_FK_KEY
,      EVENT_OFFER_REG_FK_KEY
,      EXCHANGE_RATE
,      GL_ACCT10_FK_KEY
,      GL_ACCT1_FK_KEY
,      GL_ACCT2_FK_KEY
,      GL_ACCT3_FK_KEY
,      GL_ACCT4_FK_KEY
,      GL_ACCT5_FK_KEY
,      GL_ACCT6_FK_KEY
,      GL_ACCT7_FK_KEY
,      GL_ACCT8_FK_KEY
,      GL_ACCT9_FK_KEY
,      GL_DATE_FK_KEY
,      SET_OF_BOOKS_FK_KEY
,      INSTANCE_FK_KEY
,      ITEM_FK_KEY
,      QTY_CREDITED
,      INVOICE_LINE_QTY
,      ORDER_LINE_QTY
,      MARKET_SEGMENT_FK_KEY
,      MEDIA_ACTL_FK_KEY
,      MEDIA_INIT_FK_KEY
,      OFFER_ACTL_FK_KEY
,      OFFER_INIT_FK_KEY
,      ORGANIZATION_FK_KEY
,      PARENT_ITEM_FK_KEY
,      PAYMENT_TERM_FK_KEY
,      PRIM_SALESREP_FK_KEY
,      PROJECT_FK_KEY
,      SALESCHANNEL_FK_KEY
,      SALESREP_FK_KEY
,      SHIP_TO_CUSTOMER_FK_KEY
,      SHIP_TO_SITE_FK_KEY
,      SIC_CODE_FK_KEY
,      SOLD_TO_CUSTOMER_FK_KEY
,      SOLD_TO_SITE_FK_KEY
,      SOURCE_LIST_FK_KEY
,      TRANSACTION_CURRENCY_FK_KEY
,      UNIT_SELLING_PRICE
,      SO_LINE_SELLING_PRICE
,      UOM_FK_KEY
,      USER_FK1_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      CAMPAIGN_STATUS_INIT_FK_KEY
,      CAMPAIGN_STATUS_ACTL_FK_KEY
,      AGREEMENT_TYPE
,      INVOICE_SOURCE_NAME
,      PROCESS_TYPE
,      EXCHANGE_RATE_TYPE
,      INSTANCE
,      LINE_TYPE
,      ORDER_LINE_ID
,      SALES_ORDER_NUMBER
,      INVOICE_REASON
,      INVOICE_PK
,      INVOICE_PK_KEY
,      INVOICE_NUMBER
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE16
,      USER_ATTRIBUTE17
,      USER_ATTRIBUTE18
,      USER_ATTRIBUTE19
,      USER_ATTRIBUTE20
,      USER_ATTRIBUTE21
,      USER_ATTRIBUTE22
,      USER_ATTRIBUTE23
,      USER_ATTRIBUTE24
,      USER_ATTRIBUTE25
,      EXCHANGE_DATE
,      GL_DATE
,      INVOICE_DATE
,      TRANSACTION_STATUS
,      TRANSACTION_CLASS
,      GL_POSTED_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ACCOUNT_TYPE
,      ACCOUNT_CLASS
,      COMPANY_CC_ORG_FK_KEY
,      SALESRESOURCE_FK_KEY
,      PRIM_SALESRESOURCE_FK_KEY
FROM FII.FII_AR_TRX_DIST_F;

Dependencies

[top of page]

FII.FII_AR_TRX_DIST_F does not reference any database object

FII.FII_AR_TRX_DIST_F is referenced by following:

APPS: FII_AR_TRX_DIST_F