[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;
|
|
|