[Home] [Help] [Dependency Information]
Object Name: | JG_ZZ_AP_IR_REP_ITF_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JG.JG_ZZ_AP_IR_REP_ITF_V |
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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
REQUEST_ID | NUMBER | (15) | Yes | |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | ||
ORGANIZATION_NAME | VARCHAR2 | (80) | ||
INVOICE_ID | NUMBER | Yes | ||
BATCH_ID | NUMBER | (15) | ||
BATCH_NAME | VARCHAR2 | (50) | ||
VENDOR_ID | NUMBER | (15) | ||
SUPPLIER_NAME | VARCHAR2 | (240) | ||
SUPPLIER_NAME_ALT | VARCHAR2 | (320) | ||
SUPPLIER_NUMBER | VARCHAR2 | (30) | Yes | |
SUPPLIER_SITE | VARCHAR2 | (15) | ||
INVOICE_NUM | VARCHAR2 | (50) | Yes | |
INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
DOC_SEQUENCE_NAME | VARCHAR2 | (30) | ||
DOC_SEQUENCE_VALUE | NUMBER | |||
INVOICE_DATE | DATE | |||
INVOICE_AMOUNT | NUMBER | |||
INVOICE_AMOUNT_REMAINING | NUMBER | |||
INVOICE_DESCRIPTION | VARCHAR2 | (240) | ||
INVOICE_TYPE | VARCHAR2 | (80) | Yes | |
PAYMENT_METHOD | VARCHAR2 | (100) | Yes | |
LIABILITY_CCID | NUMBER | |||
LIABILITY_ACCOUNT | VARCHAR2 | (2000) | ||
LIABILITY_DESC | VARCHAR2 | (2000) | ||
LIABILITY_NATACC | VARCHAR2 | (2000) | ||
LIABILITY_NATACC_DESC | VARCHAR2 | (2000) | ||
LINE_NUMBER | NUMBER | |||
LINE_TYPE | VARCHAR2 | (80) | ||
LINE_TYPE_DESCRIPTION | VARCHAR2 | (240) | ||
LINE_AMOUNT | NUMBER | |||
INVOICE_DISTRIBUTION_ID | NUMBER | |||
DISTRIBUTION_TYPE | VARCHAR2 | (80) | ||
DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | ||
DISTRIBUTION_LINE_AMOUNT | NUMBER | |||
DISTRIBUTION_DESCRIPTION | VARCHAR2 | (240) | ||
DISTRIBUTION_ACCT_DATE | DATE | |||
INCOME_TAX_TYPE | VARCHAR2 | (10) | ||
TAX_CODE | VARCHAR2 | (30) | ||
TAX_RATE | NUMBER | |||
POSTED_FLAG | VARCHAR2 | (80) | ||
DISTRIBUTION_CCID | NUMBER | |||
DISTRIBUTION_ACCOUNT | VARCHAR2 | (2000) | ||
DISTRIBUTION_ACCOUNT_DESC | VARCHAR2 | (2000) | ||
DISTRIBUTION_NATACC | VARCHAR2 | (2000) | ||
DISTRIBUTION_NATACC_DESC | VARCHAR2 | (2000) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, REQUEST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, FUNCTIONAL_CURRENCY_CODE
, ORGANIZATION_NAME
, INVOICE_ID
, BATCH_ID
, BATCH_NAME
, VENDOR_ID
, SUPPLIER_NAME
, SUPPLIER_NAME_ALT
, SUPPLIER_NUMBER
, SUPPLIER_SITE
, INVOICE_NUM
, INVOICE_CURRENCY_CODE
, DOC_SEQUENCE_NAME
, DOC_SEQUENCE_VALUE
, INVOICE_DATE
, INVOICE_AMOUNT
, INVOICE_AMOUNT_REMAINING
, INVOICE_DESCRIPTION
, INVOICE_TYPE
, PAYMENT_METHOD
, LIABILITY_CCID
, LIABILITY_ACCOUNT
, LIABILITY_DESC
, LIABILITY_NATACC
, LIABILITY_NATACC_DESC
, LINE_NUMBER
, LINE_TYPE
, LINE_TYPE_DESCRIPTION
, LINE_AMOUNT
, INVOICE_DISTRIBUTION_ID
, DISTRIBUTION_TYPE
, DISTRIBUTION_LINE_NUMBER
, DISTRIBUTION_LINE_AMOUNT
, DISTRIBUTION_DESCRIPTION
, DISTRIBUTION_ACCT_DATE
, INCOME_TAX_TYPE
, TAX_CODE
, TAX_RATE
, POSTED_FLAG
, DISTRIBUTION_CCID
, DISTRIBUTION_ACCOUNT
, DISTRIBUTION_ACCOUNT_DESC
, DISTRIBUTION_NATACC
, DISTRIBUTION_NATACC_DESC
FROM APPS.JG_ZZ_AP_IR_REP_ITF_V;
APPS.JG_ZZ_AP_IR_REP_ITF_V is not referenced by any database object
|
|
|