[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FII_AR_TRX_DIST_FCV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  FII.FII_AR_TRX_DIST_FCV
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SEQ_ID | NUMBER | (15) | ||
| VIEW_TYPE | VARCHAR2 | (10) | ||
| INVOICE_PK | VARCHAR2 | (115) | ||
| FUNCTIONAL_CURRENCY_FK | VARCHAR2 | (15) | ||
| BILL_TO_CUSTOMER_FK | VARCHAR2 | (85) | ||
| BILL_TO_SITE_FK | VARCHAR2 | (82) | ||
| CAMPAIGN_ACTL_FK | CHAR | (6) | ||
| CAMPAIGN_INIT_FK | CHAR | (6) | ||
| CAMPAIGN_STATUS_ACTL_FK | CHAR | (6) | ||
| CAMPAIGN_STATUS_INIT_FK | CHAR | (6) | ||
| CELL_ACTL_FK | CHAR | (6) | ||
| CELL_INIT_FK | CHAR | (6) | ||
| COMPANY_CC_ORG_FK | CHAR | (6) | ||
| EVENT_OFFER_ACTL_FK | CHAR | (6) | ||
| EVENT_OFFER_INIT_FK | CHAR | (6) | ||
| EVENT_OFFER_REG_FK | CHAR | (6) | ||
| GL_DATE_FK | VARCHAR2 | (76) | ||
| SET_OF_BOOKS_FK | VARCHAR2 | (71) | ||
| INSTANCE_FK | VARCHAR2 | (30) | ||
| ITEM_FK | VARCHAR2 | (117) | ||
| MARKET_SEGMENT_FK | CHAR | (6) | ||
| MEDIA_ACTL_FK | CHAR | (6) | ||
| MEDIA_INIT_FK | CHAR | (6) | ||
| OFFER_ACTL_FK | CHAR | (6) | ||
| OFFER_INIT_FK | CHAR | (6) | ||
| ORGANIZATION_FK | VARCHAR2 | (71) | ||
| PARENT_ITEM_FK | VARCHAR2 | (117) | ||
| PAYMENT_TERM_FK | VARCHAR2 | (74) | ||
| PRIM_SALESRESOURCE_FK | VARCHAR2 | (126) | ||
| PROJECT_FK | VARCHAR2 | (78) | ||
| SALESCHANNEL_FK | VARCHAR2 | (61) | ||
| SALESRESOURCE_FK | VARCHAR2 | (126) | ||
| SHIP_TO_CUSTOMER_FK | VARCHAR2 | (85) | ||
| SHIP_TO_SITE_FK | VARCHAR2 | (82) | ||
| SIC_CODE_FK | VARCHAR2 | (30) | ||
| SOLD_TO_CUSTOMER_FK | VARCHAR2 | (86) | ||
| SOLD_TO_SITE_FK | VARCHAR2 | (82) | ||
| SOURCE_LIST_FK | CHAR | (6) | ||
| TRANSACTION_CURRENCY_FK | VARCHAR2 | (15) | ||
| END_USER_CUSTOMER_FK | CHAR | (6) | ||
| RESELLER_CUSTOMER_FK | CHAR | (6) | ||
| INVOICE_DATE_FK | VARCHAR2 | (76) | ||
| SALES_ORDER_DATE_FK | VARCHAR2 | (76) | ||
| UOM_FK | VARCHAR2 | (4000) | ||
| AMT_B | NUMBER | |||
| AMT_G | NUMBER | |||
| AMT_T | NUMBER | |||
| UNIT_SELLING_PRICE | NUMBER | |||
| SO_LINE_SELLING_PRICE | NUMBER | |||
| ACCOUNT_ID | NUMBER | |||
| INVOICE_LINE_ID | VARCHAR2 | (25) | ||
| INVOICE_LINE_NUMBER | VARCHAR2 | (10) | ||
| EXCHANGE_RATE | NUMBER | |||
| QTY_CREDITED_NC | NUMBER | |||
| INVOICE_LINE_QTY_NC | NUMBER | |||
| ORDER_LINE_QTY_NC | NUMBER | |||
| INVOICE_SOURCE_NAME | VARCHAR2 | (50) | ||
| PROCESS_TYPE | VARCHAR2 | (1) | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
| LINE_TYPE | VARCHAR2 | (0) | ||
| INVOICE_REASON | VARCHAR2 | (30) | ||
| INVOICE_NUMBER | VARCHAR2 | (20) | ||
| AGREEMENT_TYPE | VARCHAR2 | (30) | ||
| AGREEMENT_NAME | VARCHAR2 | (30) | ||
| SALES_ORDER_NUMBER | VARCHAR2 | (150) | ||
| ORDER_LINE_ID | VARCHAR2 | (50) | ||
| EXCHANGE_DATE | DATE | |||
| INVOICE_DATE | DATE | |||
| GL_DATE | DATE | |||
| INSTANCE | VARCHAR2 | (30) | ||
| BILL_TO_CUSTOMER_ID | NUMBER | (15) | ||
| BILL_TO_ADDRESS_ID | NUMBER | (15) | ||
| CUST_PO_NUMBER | VARCHAR2 | (50) | ||
| ORDER_LINE_SOURCE_DOC_TYPE_ID | NUMBER | |||
| ORDER_LINE_TYPE_ID | NUMBER | |||
| INTERFACE_HEADER_CONTEXT | VARCHAR2 | (30) | ||
| GL_ACCT1_FK | CHAR | (6) | ||
| GL_ACCT2_FK | CHAR | (6) | ||
| GL_ACCT3_FK | CHAR | (6) | ||
| GL_ACCT4_FK | CHAR | (6) | ||
| GL_ACCT5_FK | CHAR | (6) | ||
| GL_ACCT6_FK | CHAR | (6) | ||
| GL_ACCT7_FK | CHAR | (6) | ||
| GL_ACCT8_FK | CHAR | (6) | ||
| GL_ACCT9_FK | CHAR | (6) | ||
| GL_ACCT10_FK | CHAR | (6) | ||
| USER_FK1 | CHAR | (6) | ||
| USER_FK2 | CHAR | (6) | ||
| USER_FK3 | CHAR | (6) | ||
| USER_FK4 | CHAR | (6) | ||
| USER_FK5 | CHAR | (6) | ||
| USER_MEASURE1 | NUMBER | |||
| USER_MEASURE2 | NUMBER | |||
| USER_MEASURE3 | NUMBER | |||
| USER_MEASURE4 | NUMBER | |||
| USER_MEASURE5 | NUMBER | |||
| USER_ATTRIBUTE1 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE2 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE3 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE4 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE5 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE6 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE7 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE8 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE9 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE10 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE11 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE12 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE13 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE14 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE15 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE16 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE17 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE18 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE19 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE20 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE21 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE22 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE23 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE24 | VARCHAR2 | (0) | ||
| USER_ATTRIBUTE25 | VARCHAR2 | (0) | ||
| ORG_ID | NUMBER | (15) | Organization identifier | |
| INVENTORY_ITEM_ID | NUMBER | |||
| INT_LINE_ATTR1 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR6 | VARCHAR2 | (150) | ||
| UOM_CONV_RATE | NUMBER | |||
| SET_OF_BOOKS_ID | NUMBER | (15) | ||
| INVOICE_LINE_MEMO | VARCHAR2 | (50) | ||
| SALES_ORDER_LINE_NUMBER | VARCHAR2 | (30) | ||
| SALES_ORDER_SOURCE | VARCHAR2 | (50) | ||
| ORIGINAL_INVOICE_NUM | VARCHAR2 | (20) | ||
| ORIGINAL_INVOICE_LINE_NUM | VARCHAR2 | (10) | ||
| INVOICE_ID | VARCHAR2 | (25) | ||
| INVOICE_DIST_ID | VARCHAR2 | (25) | ||
| ORIGINAL_INVOICE_ID | VARCHAR2 | (15) | ||
| ORIGINAL_INVOICE_LINE_ID | VARCHAR2 | (25) | ||
| ACCOUNT_TYPE | VARCHAR2 | (3) | ||
| ACCOUNT_CLASS | VARCHAR2 | (3) | ||
| INTERNAL_FLAG | VARCHAR2 | (3) | ||
| INTERFACE_LINE_CONTEXT | VARCHAR2 | (30) | ||
| INT_LINE_ATTR2 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR3 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR4 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR5 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR7 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR8 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR9 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR10 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR11 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR12 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR13 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR14 | VARCHAR2 | (150) | ||
| INT_LINE_ATTR15 | VARCHAR2 | (150) | ||
| GL_POSTED_DATE | DATE | |||
| TRANSACTION_CLASS | VARCHAR2 | (3) | ||
| TRANSACTION_STATUS | VARCHAR2 | (0) | ||
| GLOBAL_CURRENCY_RATE | NUMBER |
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
, 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
, BILL_TO_CUSTOMER_ID
, BILL_TO_ADDRESS_ID
, CUST_PO_NUMBER
, ORDER_LINE_SOURCE_DOC_TYPE_ID
, ORDER_LINE_TYPE_ID
, INTERFACE_HEADER_CONTEXT
, GL_ACCT1_FK
, GL_ACCT2_FK
, GL_ACCT3_FK
, GL_ACCT4_FK
, GL_ACCT5_FK
, GL_ACCT6_FK
, GL_ACCT7_FK
, GL_ACCT8_FK
, GL_ACCT9_FK
, GL_ACCT10_FK
, 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
, ORG_ID
, INVENTORY_ITEM_ID
, INT_LINE_ATTR1
, INT_LINE_ATTR6
, UOM_CONV_RATE
, SET_OF_BOOKS_ID
, 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_ATTR2
, INT_LINE_ATTR3
, INT_LINE_ATTR4
, INT_LINE_ATTR5
, 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
, GL_POSTED_DATE
, TRANSACTION_CLASS
, TRANSACTION_STATUS
, GLOBAL_CURRENCY_RATE
FROM APPS.FII_AR_TRX_DIST_FCV;
APPS
EDW_CURRENCY
- show dependent code
EDW_UTIL
- show dependent code
FIIBV_AR_TRX_DIST_FCV
OPI_OPM_COMMON_PKG
- show dependent code
APPS
FII_AR_TRX_DIST_F_C
- show dependent code
|
|
|
|