[Home] [Help] [Dependency Information]
Object Name: | AP_PREPAY_APP_DISTS# |
---|---|
Object Type: | VIEW |
Owner: | AP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREPAY_APP_DIST_ID | NUMBER | (15) | Yes | |
PREPAY_DIST_LOOKUP_CODE | VARCHAR2 | (30) | Yes | |
INVOICE_DISTRIBUTION_ID | NUMBER | (15) | Yes | |
PREPAY_APP_DISTRIBUTION_ID | NUMBER | (15) | Yes | |
ACCOUNTING_EVENT_ID | NUMBER | (15) | ||
PREPAY_HISTORY_ID | NUMBER | (15) | ||
PREPAY_EXCHANGE_DATE | DATE | |||
PREPAY_PAY_EXCHANGE_DATE | DATE | |||
PREPAY_CLR_EXCHANGE_DATE | DATE | |||
PREPAY_EXCHANGE_RATE | NUMBER | |||
PREPAY_PAY_EXCHANGE_RATE | NUMBER | |||
PREPAY_CLR_EXCHANGE_RATE | NUMBER | |||
PREPAY_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
PREPAY_PAY_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
PREPAY_CLR_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
REVERSED_PREPAY_APP_DIST_ID | NUMBER | (15) | ||
AMOUNT | NUMBER | |||
BASE_AMT_AT_PREPAY_XRATE | NUMBER | |||
BASE_AMT_AT_PREPAY_PAY_XRATE | NUMBER | |||
BASE_AMOUNT | NUMBER | |||
BASE_AMT_AT_PREPAY_CLR_XRATE | NUMBER | |||
ROUNDING_AMT | NUMBER | |||
ROUND_AMT_AT_PREPAY_XRATE | NUMBER | |||
ROUND_AMT_AT_PREPAY_PAY_XRATE | NUMBER | |||
ROUND_AMT_AT_PREPAY_CLR_XRATE | NUMBER | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
REQUEST_ID | NUMBER | (15) | ||
AWT_RELATED_ID | NUMBER | (15) | ||
RELEASE_INV_DIST_DERIVED_FROM | NUMBER | (15) | ||
PA_ADDITION_FLAG | VARCHAR2 | (1) | ||
BC_EVENT_ID | NUMBER | (15) | ||
AMOUNT_VARIANCE | NUMBER | |||
INVOICE_BASE_AMT_VARIANCE | NUMBER | |||
QUANTITY_VARIANCE | NUMBER | |||
INVOICE_BASE_QTY_VARIANCE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PREPAY_APP_DIST_ID
, PREPAY_DIST_LOOKUP_CODE
, INVOICE_DISTRIBUTION_ID
, PREPAY_APP_DISTRIBUTION_ID
, ACCOUNTING_EVENT_ID
, PREPAY_HISTORY_ID
, PREPAY_EXCHANGE_DATE
, PREPAY_PAY_EXCHANGE_DATE
, PREPAY_CLR_EXCHANGE_DATE
, PREPAY_EXCHANGE_RATE
, PREPAY_PAY_EXCHANGE_RATE
, PREPAY_CLR_EXCHANGE_RATE
, PREPAY_EXCHANGE_RATE_TYPE
, PREPAY_PAY_EXCHANGE_RATE_TYPE
, PREPAY_CLR_EXCHANGE_RATE_TYPE
, REVERSED_PREPAY_APP_DIST_ID
, AMOUNT
, BASE_AMT_AT_PREPAY_XRATE
, BASE_AMT_AT_PREPAY_PAY_XRATE
, BASE_AMOUNT
, BASE_AMT_AT_PREPAY_CLR_XRATE
, ROUNDING_AMT
, ROUND_AMT_AT_PREPAY_XRATE
, ROUND_AMT_AT_PREPAY_PAY_XRATE
, ROUND_AMT_AT_PREPAY_CLR_XRATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, AWT_RELATED_ID
, RELEASE_INV_DIST_DERIVED_FROM
, PA_ADDITION_FLAG
, BC_EVENT_ID
, AMOUNT_VARIANCE
, INVOICE_BASE_AMT_VARIANCE
, QUANTITY_VARIANCE
, INVOICE_BASE_QTY_VARIANCE
FROM AP.AP_PREPAY_APP_DISTS#;
|
|
|