[Home] [Help] [Dependency Information]
Object Name: | OKS_RULES_DFF_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (90) | Yes | |
X_ACCTRULE | VARCHAR2 | (30) | Yes | |
OKS_BPE_ID | VARCHAR2 | (450) | ||
PROFILE_LEVEL | VARCHAR2 | (450) | ||
ALLOW_FULL_DISCOUNT | VARCHAR2 | (450) | ||
CREDIT_CARD_NO | VARCHAR2 | (450) | ||
EXIPRY_DATE | DATE | |||
BANK_ACCOUNT_ID | NUMBER | |||
AUTHORIZATION_CODE | VARCHAR2 | (450) | ||
COVERAGE_TYPE | VARCHAR2 | (450) | ||
CLE_ID | VARCHAR2 | (450) | ||
BILLING_PROFILE_ID | VARCHAR2 | (450) | ||
RENEWAL_STATUS | VARCHAR2 | (450) | ||
ELECTRONIC_RENEWAL_FLAG_YN | VARCHAR2 | (450) | ||
GPR_GRACE_DURATION | NUMBER | |||
GPR_GRACE_PERIOD | VARCHAR2 | (450) | ||
IB_TRANSACTION_TYPE | VARCHAR2 | (450) | ||
IB_TRANSACTION_DATE | DATE | |||
IB_TRANSACTION_DETAILS | VARCHAR2 | (450) | ||
X_INVTEXT | VARCHAR2 | (450) | ||
INVOICE_PRINT_FLAG | VARCHAR2 | (450) | ||
PRICE_UOM | VARCHAR2 | (450) | ||
TAX_AMOUNT | NUMBER | |||
TAX_INCLUSIVE_FLAG_YN | VARCHAR2 | (450) | ||
TOTAL_AMOUNT | NUMBER | |||
UOM_QUANTIFIED | VARCHAR2 | (450) | ||
AMOUNT_MAX | NUMBER | |||
AMOUNT_MIN | NUMBER | |||
PERCENT_MAX | NUMBER | |||
PERCENT_MIN | NUMBER | |||
QUANTITY_MAX | NUMBER | |||
QUANTITY_MIN | NUMBER | |||
TVE_ID | VARCHAR2 | (450) | ||
X_PRODUCT_PRICE | VARCHAR2 | (30) | Yes | |
X_SERVICE_PRICE | VARCHAR2 | (30) | Yes | |
CLVL_LIST_PRICE | NUMBER | |||
CLVL_QUANTITY | NUMBER | |||
CLVL_UOM_CODE | VARCHAR2 | (450) | ||
CLVL_EXTENDED_AMOUNT | NUMBER | |||
TLVL_LIST_PRICE | NUMBER | |||
TLVL_OPERAND_CODE | VARCHAR2 | (450) | ||
TLVL_OPERAND_VALUE | NUMBER | |||
TLVL_QUANTITY | NUMBER | |||
TLVL_UOM_CODE | VARCHAR2 | (450) | ||
TLVL_ADJUSTED_PRICE | NUMBER | |||
TLVL_EXTENDED_AMOUNT | NUMBER | |||
STATUS_TEXT | VARCHAR2 | (450) | ||
TLVL_PRICED_QTY | NUMBER | |||
OKX_PMACTV | VARCHAR2 | (30) | Yes | |
OKS_PMPRULE | VARCHAR2 | (30) | Yes | |
SELECT_FLAG | VARCHAR2 | (450) | ||
CONFIRMATION_REQUIRED | VARCHAR2 | (450) | ||
SCHEDULE_EXISTS | VARCHAR2 | (450) | ||
OKX_PMPROG | VARCHAR2 | (30) | ||
SEQ_NO | NUMBER | |||
PERIODS | NUMBER | |||
START_DATE | DATE | |||
END_DATE | DATE | |||
UOM_PERIOD | NUMBER | |||
UOM | VARCHAR2 | (450) | ||
OFFSET_PERIOD | NUMBER | |||
OFFSET_UOM | VARCHAR2 | (450) | ||
AUTO_SCHEDULE | VARCHAR2 | (450) | ||
PMP_RULE | VARCHAR2 | (30) | Yes | |
OKS_PMARULE | VARCHAR2 | (30) | Yes | |
AVERAGE_INVOICE_FREQ | NUMBER | |||
UOM_LIMITED | VARCHAR2 | (450) | ||
SETTLE_TO_ACTUALS_FREQ | NUMBER | |||
RATE_MINIMUM | NUMBER | |||
RATE_DEFAULT | NUMBER | |||
RATE_DEFAULT_MACV_YN | VARCHAR2 | (450) | ||
RATE | NUMBER | |||
NO_OF_TUOM_PER | NUMBER | |||
LEVEL_YN | VARCHAR2 | (450) | ||
QUANTITY_RATE_TYPE | VARCHAR2 | (450) | ||
BILLED_TOLERANCE_DAYS | NUMBER | |||
BASE_READING | NUMBER | |||
X_QTO_CONTACT_ID | VARCHAR2 | (30) | Yes | |
X_QTO_SITE_ID | VARCHAR2 | (30) | Yes | |
QTO_EMAIL | VARCHAR2 | (450) | ||
QTO_PHONE | VARCHAR2 | (450) | ||
QTO_FAX | VARCHAR2 | (450) | ||
PDF_ID | VARCHAR2 | (450) | ||
NAME | VARCHAR2 | (450) | ||
WORK_THRU_YN | VARCHAR2 | (450) | ||
ACTIVE_YN | VARCHAR2 | (450) | ||
X_REACTIME | VARCHAR2 | (30) | Yes | |
ESTIMATED_REVENUE_PERCENT | NUMBER | |||
ESTIMATED_DURATION | NUMBER | |||
ESTIMATED_PERIOD | VARCHAR2 | (450) | ||
RENEWAL_PO | VARCHAR2 | (450) | ||
RENEWAL_PRICING_TYPE | VARCHAR2 | (450) | ||
X_PRICE | VARCHAR2 | (30) | ||
RENEWAL_MARKUP_PERCENT | NUMBER | |||
GRACE_DURATION | NUMBER | |||
GRACE_PERIOD | VARCHAR2 | (450) | ||
RENEWAL_TYPE | VARCHAR2 | (450) | ||
NOTIFICATION_TO | VARCHAR2 | (450) | ||
REVENUE_ESTIMATION_PERCENT | NUMBER | |||
ESTIMATION_DURATION | NUMBER | |||
ESTIMATION_PERIOD | VARCHAR2 | (450) | ||
EVN_THRESHOLD_AMT | NUMBER | |||
EVN_THRESHOLD_CUR | VARCHAR2 | (450) | ||
ERN_THRESHOLD_AMT | NUMBER | |||
ERN_THRESHOLD_CUR | VARCHAR2 | (450) | ||
FLAT_RATE | NUMBER | |||
PERCENT_RATE | NUMBER | |||
BILLING_RATE_CODE | VARCHAR2 | (450) | ||
X_BILLRATE | VARCHAR2 | (30) | Yes | |
RSN_PDF_ID | VARCHAR2 | (450) | ||
RSN_NAME | VARCHAR2 | (450) | ||
RSN_WORK_THRU_YN | VARCHAR2 | (450) | ||
RSN_ACTIVE_YN | VARCHAR2 | (450) | ||
RSN_X_REACTIME | VARCHAR2 | (30) | Yes | |
ESTIMATION_PERCENT | NUMBER | |||
DATE_ESTIMATED | DATE | |||
DURATION | NUMBER | |||
PERIOD | VARCHAR2 | (450) | ||
FIRST_BILLTO_DATE | DATE | |||
FIRST_INVOICE_DATE | DATE | |||
REG_INVOICE_PRI_OFFSET | NUMBER | |||
UOM_PRI_OFFSET | VARCHAR2 | (450) | ||
REG_INVOICE_SEC_OFFSET | NUMBER | |||
UOM_SEC_OFFSET | VARCHAR2 | (450) | ||
INVOICE_PRINT_PROFILE | VARCHAR2 | (450) | ||
RENEWAL_PO_NUMBER | VARCHAR2 | (450) | ||
AR_INTERFACE_YN | VARCHAR2 | (450) | ||
X_TRXTYPE | VARCHAR2 | (30) | Yes | |
HOLD_BILLING | VARCHAR2 | (450) | ||
SUMMARY_TRANSACTION | VARCHAR2 | (450) | ||
STREAM_TYPE | VARCHAR2 | (30) | Yes | |
TIME_VALUE | VARCHAR2 | (30) | Yes | |
BILLING_SCH_TYPE | VARCHAR2 | (450) | ||
I_TUOM | VARCHAR2 | (30) | Yes | |
STREAM_LEVEL_HEADER | VARCHAR2 | (30) | Yes | |
SEQUENCE_NUMBER | VARCHAR2 | (450) | ||
DATE_START | DATE | |||
LEVEL_PERIODS | VARCHAR2 | (450) | ||
TUOMS_PER_PERIOD | VARCHAR2 | (450) | ||
ADVANCE_PERIODS | VARCHAR2 | (450) | ||
AMOUNT_SLL | VARCHAR2 | (450) | ||
ACTION_OFFSET_DAYS | VARCHAR2 | (450) | ||
INTERFACE_OFFSET_DAYS | VARCHAR2 | (450) | ||
COMMENTS | VARCHAR2 | (450) | ||
DUE_ARR_YN | VARCHAR2 | (450) | ||
AMOUNT_ACTUAL_YN | VARCHAR2 | (450) | ||
LINES_DETAILED_YN | VARCHAR2 | (450) | ||
SERVICE_PURCHASE_ORDER | VARCHAR2 | (450) | ||
SERVICE_PO_REQUIRED | VARCHAR2 | (450) | ||
TRANSFER_YN | VARCHAR2 | (450) | ||
TAX_STATUS | VARCHAR2 | (450) | ||
TAX_POINT | VARCHAR2 | (450) | ||
X_TAXEXEMP | VARCHAR2 | (30) | Yes | |
X_TAXCODE | VARCHAR2 | (30) | Yes | |
AUTO_COVERED_YN | VARCHAR2 | (450) | ||
USV_OLD_ITEM_ID | NUMBER | |||
USV_NEW_ITEM_ID | NUMBER | |||
USV_OLD_CLE_ID | NUMBER | |||
INHERITANCE_TYPE | VARCHAR2 | (450) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, X_ACCTRULE
, OKS_BPE_ID
, PROFILE_LEVEL
, ALLOW_FULL_DISCOUNT
, CREDIT_CARD_NO
, EXIPRY_DATE
, BANK_ACCOUNT_ID
, AUTHORIZATION_CODE
, COVERAGE_TYPE
, CLE_ID
, BILLING_PROFILE_ID
, RENEWAL_STATUS
, ELECTRONIC_RENEWAL_FLAG_YN
, GPR_GRACE_DURATION
, GPR_GRACE_PERIOD
, IB_TRANSACTION_TYPE
, IB_TRANSACTION_DATE
, IB_TRANSACTION_DETAILS
, X_INVTEXT
, INVOICE_PRINT_FLAG
, PRICE_UOM
, TAX_AMOUNT
, TAX_INCLUSIVE_FLAG_YN
, TOTAL_AMOUNT
, UOM_QUANTIFIED
, AMOUNT_MAX
, AMOUNT_MIN
, PERCENT_MAX
, PERCENT_MIN
, QUANTITY_MAX
, QUANTITY_MIN
, TVE_ID
, X_PRODUCT_PRICE
, X_SERVICE_PRICE
, CLVL_LIST_PRICE
, CLVL_QUANTITY
, CLVL_UOM_CODE
, CLVL_EXTENDED_AMOUNT
, TLVL_LIST_PRICE
, TLVL_OPERAND_CODE
, TLVL_OPERAND_VALUE
, TLVL_QUANTITY
, TLVL_UOM_CODE
, TLVL_ADJUSTED_PRICE
, TLVL_EXTENDED_AMOUNT
, STATUS_TEXT
, TLVL_PRICED_QTY
, OKX_PMACTV
, OKS_PMPRULE
, SELECT_FLAG
, CONFIRMATION_REQUIRED
, SCHEDULE_EXISTS
, OKX_PMPROG
, SEQ_NO
, PERIODS
, START_DATE
, END_DATE
, UOM_PERIOD
, UOM
, OFFSET_PERIOD
, OFFSET_UOM
, AUTO_SCHEDULE
, PMP_RULE
, OKS_PMARULE
, AVERAGE_INVOICE_FREQ
, UOM_LIMITED
, SETTLE_TO_ACTUALS_FREQ
, RATE_MINIMUM
, RATE_DEFAULT
, RATE_DEFAULT_MACV_YN
, RATE
, NO_OF_TUOM_PER
, LEVEL_YN
, QUANTITY_RATE_TYPE
, BILLED_TOLERANCE_DAYS
, BASE_READING
, X_QTO_CONTACT_ID
, X_QTO_SITE_ID
, QTO_EMAIL
, QTO_PHONE
, QTO_FAX
, PDF_ID
, NAME
, WORK_THRU_YN
, ACTIVE_YN
, X_REACTIME
, ESTIMATED_REVENUE_PERCENT
, ESTIMATED_DURATION
, ESTIMATED_PERIOD
, RENEWAL_PO
, RENEWAL_PRICING_TYPE
, X_PRICE
, RENEWAL_MARKUP_PERCENT
, GRACE_DURATION
, GRACE_PERIOD
, RENEWAL_TYPE
, NOTIFICATION_TO
, REVENUE_ESTIMATION_PERCENT
, ESTIMATION_DURATION
, ESTIMATION_PERIOD
, EVN_THRESHOLD_AMT
, EVN_THRESHOLD_CUR
, ERN_THRESHOLD_AMT
, ERN_THRESHOLD_CUR
, FLAT_RATE
, PERCENT_RATE
, BILLING_RATE_CODE
, X_BILLRATE
, RSN_PDF_ID
, RSN_NAME
, RSN_WORK_THRU_YN
, RSN_ACTIVE_YN
, RSN_X_REACTIME
, ESTIMATION_PERCENT
, DATE_ESTIMATED
, DURATION
, PERIOD
, FIRST_BILLTO_DATE
, FIRST_INVOICE_DATE
, REG_INVOICE_PRI_OFFSET
, UOM_PRI_OFFSET
, REG_INVOICE_SEC_OFFSET
, UOM_SEC_OFFSET
, INVOICE_PRINT_PROFILE
, RENEWAL_PO_NUMBER
, AR_INTERFACE_YN
, X_TRXTYPE
, HOLD_BILLING
, SUMMARY_TRANSACTION
, STREAM_TYPE
, TIME_VALUE
, BILLING_SCH_TYPE
, I_TUOM
, STREAM_LEVEL_HEADER
, SEQUENCE_NUMBER
, DATE_START
, LEVEL_PERIODS
, TUOMS_PER_PERIOD
, ADVANCE_PERIODS
, AMOUNT_SLL
, ACTION_OFFSET_DAYS
, INTERFACE_OFFSET_DAYS
, COMMENTS
, DUE_ARR_YN
, AMOUNT_ACTUAL_YN
, LINES_DETAILED_YN
, SERVICE_PURCHASE_ORDER
, SERVICE_PO_REQUIRED
, TRANSFER_YN
, TAX_STATUS
, TAX_POINT
, X_TAXEXEMP
, X_TAXCODE
, AUTO_COVERED_YN
, USV_OLD_ITEM_ID
, USV_NEW_ITEM_ID
, USV_OLD_CLE_ID
, INHERITANCE_TYPE
, CONCATENATED_SEGMENTS
FROM APPS.OKS_RULES_DFF_DFV;
APPS.OKS_RULES_DFF_DFV is not referenced by any database object
|
|
|