[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FIIBV_AR_TRX_DIST_FCV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
FIIBV_AR_TRX_DIST_FCV is the base view for FII_AR_TRX_DIST_F fact
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SEQ_ID | NUMBER | (15) | This column is for internal use only | |
| VIEW_TYPE | VARCHAR2 | (10) | This column is for internal use only | |
| INVOICE_PK | VARCHAR2 | (115) | This is a unique key for the AR Revenue Fact. It is a concatenation of Oracle Applications Customer Transaction Line and GL Distribution table. | |
| FUNCTIONAL_CURRENCY_FK | VARCHAR2 | (15) | A foreign key generated by the warehouse that points to the functional currency dimension at the lowest level. | |
| BILL_TO_CUSTOMER_FK | VARCHAR2 | (85) | A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level. | |
| BILL_TO_SITE_FK | VARCHAR2 | (82) | A foreign key generated by the warehouse that points to the geography dimension at the lowest level. | |
| CAMPAIGN_ACTL_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the campaign dimension at the lowest level. | |
| CAMPAIGN_INIT_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the campaign dimension at the lowest level. | |
| CAMPAIGN_STATUS_ACTL_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the campaign status dimension at the lowest level. | |
| CAMPAIGN_STATUS_INIT_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the campaign status dimension at the lowest level. | |
| CELL_ACTL_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the target segment dimension at the lowest level. | |
| CELL_INIT_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the target segment dimension at the lowest level. | |
| COMPANY_CC_ORG_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the organization dimension at the lowest level. | |
| EVENT_OFFER_ACTL_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the event dimension at the lowest level. | |
| EVENT_OFFER_INIT_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the event dimension at the lowest level. | |
| EVENT_OFFER_REG_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the event dimension at the lowest level. | |
| GL_DATE_FK | VARCHAR2 | (76) | A foreign key generated by the warehouse that points to the Time dimension at the lowest level. | |
| SET_OF_BOOKS_FK | VARCHAR2 | (71) | A foreign key generated by the warehouse that points to the set of books dimension at the lowest level. | |
| INSTANCE_FK | VARCHAR2 | (30) | A foreign key generated by the warehouse that points to the instance dimension at the lowest level. | |
| ITEM_FK | VARCHAR2 | (117) | A foreign key generated by the warehouse that points to the item dimension at the lowest level. | |
| MARKET_SEGMENT_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the market segment dimension at the lowest level. | |
| MEDIA_ACTL_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the media channel dimension at the lowest level. | |
| MEDIA_INIT_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the media channel dimension at the lowest level. | |
| OFFER_ACTL_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the offer dimension at the lowest level. | |
| OFFER_INIT_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the offer dimension at the lowest level. | |
| ORGANIZATION_FK | VARCHAR2 | (71) | A foreign key generated by the warehouse that points to the organization dimension at the lowest level. | |
| PARENT_ITEM_FK | VARCHAR2 | (117) | A foreign key generated by the warehouse that points to the item dimension at the lowest level. | |
| PAYMENT_TERM_FK | VARCHAR2 | (74) | A foreign key generated by the warehouse that points to the payment terms dimension at the lowest level. | |
| PRIM_SALESRESOURCE_FK | VARCHAR2 | (126) | A foreign key generated by the warehouse that points to the sales resource dimension at the lowest level. | |
| PROJECT_FK | VARCHAR2 | (78) | A foreign key generated by the warehouse that points to the project dimension at the lowest level. | |
| SALESCHANNEL_FK | VARCHAR2 | (61) | A foreign key generated by the warehouse that points to the sales channel dimension at the lowest level. | |
| SALESRESOURCE_FK | VARCHAR2 | (126) | A foreign key generated by the warehouse that points to the sales resource dimension at the lowest level. | |
| SHIP_TO_CUSTOMER_FK | VARCHAR2 | (85) | A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level. | |
| SHIP_TO_SITE_FK | VARCHAR2 | (82) | A foreign key generated by the warehouse that points to the geography dimension at the lowest level. | |
| SIC_CODE_FK | VARCHAR2 | (30) | A foreign key generated by the warehouse that points to the standard industry code, SIC, dimension at the lowest level. | |
| SOLD_TO_CUSTOMER_FK | VARCHAR2 | (86) | A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level. | |
| SOLD_TO_SITE_FK | VARCHAR2 | (82) | A foreign key generated by the warehouse that points to the geography dimension at the lowest level. | |
| SOURCE_LIST_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the source list dimension at the lowest level. | |
| TRANSACTION_CURRENCY_FK | VARCHAR2 | (15) | A foreign key generated by the warehouse that points to the transaction currency dimension at the lowest level. | |
| END_USER_CUSTOMER_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level. | |
| RESELLER_CUSTOMER_FK | CHAR | (6) | A foreign key generated by the warehouse that points to the trading partner dimension at the lowest level. | |
| INVOICE_DATE_FK | VARCHAR2 | (76) | A foreign key generated by the warehouse that points to the time dimension at the lowest level. | |
| SALES_ORDER_DATE_FK | VARCHAR2 | (76) | A foreign key generated by the warehouse that points to the time dimension at the lowest level. | |
| UOM_FK | VARCHAR2 | (4000) | A foreign key generated by the warehouse system that points to the unit of measure dimension at the lowest level. | |
| GL_POSTED_DATE | DATE | Date posted to General Ledger. | ||
| TRANSACTION_STATUS | VARCHAR2 | (0) | 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. | |
| GLOBAL_CURRENCY_RATE | NUMBER | |||
| 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. | ||
| UNIT_SELLING_PRICE | NUMBER | Selling price per unit for a transaction line. | ||
| SO_LINE_SELLING_PRICE | NUMBER | Selling price for sales order line. | ||
| ACCOUNT_ID | NUMBER | A source system generated identifier for the account. | ||
| 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. | |
| EXCHANGE_RATE | NUMBER | Currency exchange rate from the source system | ||
| QTY_CREDITED_NC | NUMBER | Quantity credited | ||
| INVOICE_LINE_QTY_NC | NUMBER | Quantity of invoice line | ||
| ORDER_LINE_QTY_NC | NUMBER | Quantity of an order | ||
| 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. | |
| LINE_TYPE | VARCHAR2 | (0) | The type of receivables invoice line. LIN, Regular Invoice Line. FRT, Freight Line. TAX, Tax Line. QTY, Quantity Line. ADJ, Adjustment Line. | |
| INVOICE_REASON | VARCHAR2 | (30) | Invoice reason. | |
| INVOICE_NUMBER | VARCHAR2 | (20) | A document number that is created in Oracle Receivables. | |
| AGREEMENT_TYPE | VARCHAR2 | (30) | Code used to group agreements. | |
| AGREEMENT_NAME | VARCHAR2 | (30) | The agreement name for the order. | |
| SALES_ORDER_NUMBER | VARCHAR2 | (150) | Sales order number. | |
| ORDER_LINE_ID | VARCHAR2 | (50) | A source system generated identifier for the sales order line. | |
| EXCHANGE_DATE | DATE | Date of the currency exchange rate. | ||
| INVOICE_DATE | DATE | Transaction date. | ||
| GL_DATE | DATE | General Ledger date. | ||
| INSTANCE | VARCHAR2 | (30) | The name of the instance where the fact data originated. | |
| USER_FK1 | CHAR | (6) | A foreign key generated by the warehouse that points to the user defined foreign key. | |
| USER_FK2 | CHAR | (6) | A foreign key generated by the warehouse that points to the user defined foreign key. | |
| USER_FK3 | CHAR | (6) | A foreign key generated by the warehouse that points to the user defined foreign key. | |
| USER_FK4 | CHAR | (6) | A foreign key generated by the warehouse that points to the user defined foreign key. | |
| USER_FK5 | CHAR | (6) | 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. | ||
| USER_ATTRIBUTE1 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE2 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE3 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE4 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE5 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE6 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE7 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE8 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE9 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE10 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE11 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE12 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE13 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE14 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE15 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE16 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE17 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE18 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE19 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE20 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE21 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE22 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE23 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE24 | VARCHAR2 | (0) | User defined attribute value. | |
| USER_ATTRIBUTE25 | VARCHAR2 | (0) | User defined attribute value. | |
| UOM_CONV_RATE | NUMBER | Unit of measure conversion rate | ||
| 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 | (20) | The original invoice number. | |
| ORIGINAL_INVOICE_LINE_NUM | VARCHAR2 | (10) | The original invoice line number. | |
| 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. | |
| ACCOUNT_TYPE | VARCHAR2 | (3) | 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, Recivables. UNBILL, Unbilled Receivable. UNEARN, Unearned Revenue. | |
| INTERNAL_FLAG | VARCHAR2 | (3) | For Internal purpose only. | |
| INTERFACE_LINE_CONTEXT | VARCHAR2 | (30) | Interface line context for the transaction line. | |
| INT_LINE_ATTR1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INT_LINE_ATTR15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
| INTERFACE_HEADER_CONTEXT | VARCHAR2 | (30) | This column is for internal use only | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Set of Books identifier | |
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
| BILL_TO_CUSTOMER_ID | NUMBER | (15) | Customer identifer to send bills | |
| BILL_TO_ADDRESS_ID | NUMBER | (15) | Address identifer to send bills | |
| CUST_PO_NUMBER | VARCHAR2 | (50) | Customer purschase order number | |
| ORDER_LINE_SOURCE_DOC_TYPE_ID | NUMBER | Indicates the source of the order line | ||
| ORDER_LINE_TYPE_ID | NUMBER | Order line transaction type identifier | ||
| SALESREP_FK | CHAR | (6) | ||
| PRIM_SALESREP_FK | CHAR | (6) | ||
| _KF:GL_ACCT_NUM:ACCT:_EDW | VARCHAR2 | (24) | This column is for internal use only | |
| _DF:CRA:_EDW | VARCHAR2 | (44) | This column is for internal use only | |
| _DF:CRB:_EDW | VARCHAR2 | (48) | This column is for internal use only | |
| _DF:CRC:_EDW | VARCHAR2 | (39) | This column is for internal use only | |
| _DF:CRD:_EDW | VARCHAR2 | (43) | This column is for internal use only | |
| _DF:CRE:_EDW | VARCHAR2 | (45) | This column is for internal use only | |
| _DF:CRF:_EDW | VARCHAR2 | (44) | This column is for internal use only | |
| _DF:CRG:_EDW | VARCHAR2 | (42) | This column is for internal use only | |
| _DF:CRH:_EDW | VARCHAR2 | (32) | This column is for internal use only | |
| _DF:CRI:_EDW | VARCHAR2 | (36) | This column is for internal use only | |
| _DF:CRO:_EDW | VARCHAR2 | (41) | This column is for internal use only | |
| _DF:CRP:_EDW | VARCHAR2 | (43) | This column is for internal use only | |
| _DF:CRQ:_EDW | VARCHAR2 | (51) | This column is for internal use only | |
| _DF:CRR:_EDW | VARCHAR2 | (50) | This column is for internal use only | |
| _DF:CRS:_EDW | VARCHAR2 | (49) | This column is for internal use only | |
| _DF:CRT:_EDW | VARCHAR2 | (46) | This column is for internal use only | |
| _DF:CRU:_EDW | VARCHAR2 | (38) | This column is for internal use only | |
| _DF:CRV:_EDW | VARCHAR2 | (44) | This column is for internal use only | |
| _DF:CRW:_EDW | CHAR | (25) | This column is for internal use only | |
| _DF:CRX:_EDW | CHAR | (29) | This column is for internal use only | |
| _DF:CRY:_EDW | CHAR | (29) | This column is for internal use only | |
| _DF:CRZ:_EDW | CHAR | (28) | This column is for internal use only |
Cut, paste (and edit) the following text to query this object:
SELECT SEQ_ID
, VIEW_TYPE
, INVOICE_PK
, FUNCTIONAL_CURRENCY_FK
, BILL_TO_CUSTOMER_FK
, BILL_TO_SITE_FK
, CAMPAIGN_ACTL_FK
, CAMPAIGN_INIT_FK
, CAMPAIGN_STATUS_ACTL_FK
, CAMPAIGN_STATUS_INIT_FK
, CELL_ACTL_FK
, CELL_INIT_FK
, COMPANY_CC_ORG_FK
, EVENT_OFFER_ACTL_FK
, EVENT_OFFER_INIT_FK
, EVENT_OFFER_REG_FK
, GL_DATE_FK
, SET_OF_BOOKS_FK
, INSTANCE_FK
, ITEM_FK
, MARKET_SEGMENT_FK
, MEDIA_ACTL_FK
, MEDIA_INIT_FK
, OFFER_ACTL_FK
, OFFER_INIT_FK
, ORGANIZATION_FK
, PARENT_ITEM_FK
, PAYMENT_TERM_FK
, PRIM_SALESRESOURCE_FK
, PROJECT_FK
, SALESCHANNEL_FK
, SALESRESOURCE_FK
, SHIP_TO_CUSTOMER_FK
, SHIP_TO_SITE_FK
, SIC_CODE_FK
, SOLD_TO_CUSTOMER_FK
, SOLD_TO_SITE_FK
, SOURCE_LIST_FK
, TRANSACTION_CURRENCY_FK
, END_USER_CUSTOMER_FK
, RESELLER_CUSTOMER_FK
, INVOICE_DATE_FK
, SALES_ORDER_DATE_FK
, UOM_FK
, GL_POSTED_DATE
, TRANSACTION_STATUS
, TRANSACTION_CLASS
, GLOBAL_CURRENCY_RATE
, AMT_B
, AMT_G
, AMT_T
, UNIT_SELLING_PRICE
, SO_LINE_SELLING_PRICE
, ACCOUNT_ID
, INVOICE_LINE_ID
, INVOICE_LINE_NUMBER
, EXCHANGE_RATE
, QTY_CREDITED_NC
, INVOICE_LINE_QTY_NC
, ORDER_LINE_QTY_NC
, INVOICE_SOURCE_NAME
, PROCESS_TYPE
, EXCHANGE_RATE_TYPE
, LINE_TYPE
, INVOICE_REASON
, INVOICE_NUMBER
, AGREEMENT_TYPE
, AGREEMENT_NAME
, SALES_ORDER_NUMBER
, ORDER_LINE_ID
, EXCHANGE_DATE
, INVOICE_DATE
, GL_DATE
, INSTANCE
, USER_FK1
, USER_FK2
, USER_FK3
, USER_FK4
, USER_FK5
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_ATTRIBUTE16
, USER_ATTRIBUTE17
, USER_ATTRIBUTE18
, USER_ATTRIBUTE19
, USER_ATTRIBUTE20
, USER_ATTRIBUTE21
, USER_ATTRIBUTE22
, USER_ATTRIBUTE23
, USER_ATTRIBUTE24
, USER_ATTRIBUTE25
, UOM_CONV_RATE
, INVOICE_LINE_MEMO
, SALES_ORDER_LINE_NUMBER
, SALES_ORDER_SOURCE
, ORIGINAL_INVOICE_NUM
, ORIGINAL_INVOICE_LINE_NUM
, INVOICE_ID
, INVOICE_DIST_ID
, ORIGINAL_INVOICE_ID
, ORIGINAL_INVOICE_LINE_ID
, ACCOUNT_TYPE
, ACCOUNT_CLASS
, INTERNAL_FLAG
, INTERFACE_LINE_CONTEXT
, INT_LINE_ATTR1
, INT_LINE_ATTR2
, INT_LINE_ATTR3
, INT_LINE_ATTR4
, INT_LINE_ATTR5
, INT_LINE_ATTR6
, INT_LINE_ATTR7
, INT_LINE_ATTR8
, INT_LINE_ATTR9
, INT_LINE_ATTR10
, INT_LINE_ATTR11
, INT_LINE_ATTR12
, INT_LINE_ATTR13
, INT_LINE_ATTR14
, INT_LINE_ATTR15
, INTERFACE_HEADER_CONTEXT
, SET_OF_BOOKS_ID
, ORG_ID
, INVENTORY_ITEM_ID
, BILL_TO_CUSTOMER_ID
, BILL_TO_ADDRESS_ID
, CUST_PO_NUMBER
, ORDER_LINE_SOURCE_DOC_TYPE_ID
, ORDER_LINE_TYPE_ID
, SALESREP_FK
, PRIM_SALESREP_FK
, _KF:GL_ACCT_NUM:ACCT:_EDW
, _DF:CRA:_EDW
, _DF:CRB:_EDW
, _DF:CRC:_EDW
, _DF:CRD:_EDW
, _DF:CRE:_EDW
, _DF:CRF:_EDW
, _DF:CRG:_EDW
, _DF:CRH:_EDW
, _DF:CRI:_EDW
, _DF:CRO:_EDW
, _DF:CRP:_EDW
, _DF:CRQ:_EDW
, _DF:CRR:_EDW
, _DF:CRS:_EDW
, _DF:CRT:_EDW
, _DF:CRU:_EDW
, _DF:CRV:_EDW
, _DF:CRW:_EDW
, _DF:CRX:_EDW
, _DF:CRY:_EDW
, _DF:CRZ:_EDW
FROM APPS.FIIBV_AR_TRX_DIST_FCV;
APPS
AR_ADJUSTMENTS_ALL
AR_DISTRIBUTIONS_ALL
AR_MEMO_LINES_ALL_TL
AR_RECEIVABLES_TRX_ALL
EDW_CURRENCY
- show dependent code
EDW_LOCAL_INSTANCE
EDW_UTIL
- show dependent code
FII_TMP_PK
GL_CODE_COMBINATIONS
GL_SETS_OF_BOOKS
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_SITE_USES_ALL
IC_ITEM_MST
IC_WHSE_MST
MTL_SYSTEM_ITEMS_B
OE_AGREEMENTS_B
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OPI_OPM_COMMON_PKG
- show dependent code
OP_ORDR_CHG
OP_ORDR_DTL
PA_PROJECTS_ALL
RA_BATCH_SOURCES_ALL
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
RA_CUST_TRX_LINE_GL_DIST_ALL
RA_CUST_TRX_LINE_SALESREPS_ALL
RA_CUST_TRX_TYPES_ALL
APPS
FII_AR_TRX_DIST_FCV
|
|
|
|