[Home] [Help] [Dependency Information]

VIEW: APPS.OKS_RULES_DFF_DFV

Object Details

[View Source]

Columns

Query Text

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;

Dependencies

[top of page]

APPS

FND_NUMBER - show dependent code

OKS_RULES_DFF

APPS.OKS_RULES_DFF_DFV is not referenced by any database object