[Home] [Help] [Dependency Information]
Object Name: | OE_DEF_ATTR_DEF_RULES_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
SOURCE_TYPE | VARCHAR2 | (30) | Yes | |
ACCOUNTING_RULE | VARCHAR2 | (240) | ||
AGREEMENT | VARCHAR2 | (240) | ||
PACKAGE_NAME | VARCHAR2 | (30) | ||
FUNCTION_NAME | VARCHAR2 | (2000) | ||
ATTRIBUTE1 | VARCHAR2 | (30) | ||
ATTRIBUTE2 | VARCHAR2 | (30) | ||
CALCULATE_PRICE | VARCHAR2 | (240) | ||
CHECK_NUMBER | VARCHAR2 | (240) | ||
VALUE | VARCHAR2 | (240) | ||
CONVERSION_RATE_DATE | DATE | |||
CONVERSION_TYPE | VARCHAR2 | (240) | ||
CUSTOMER_PO | VARCHAR2 | (240) | ||
DEFAULT_FULFILLMENT_SET | VARCHAR2 | (240) | ||
DEFAULT_LINE_SET | VARCHAR2 | (240) | ||
DELIVERY_LEAD_TIME | NUMBER | |||
DELIVER_TO | VARCHAR2 | (240) | ||
DEMAND_CLASS | VARCHAR2 | (240) | ||
DEPARTURE_PLANNING_REQUIRED | VARCHAR2 | (240) | ||
EARLIEST_ACCEPTABLE_DATE | DATE | |||
EARLIEST_SCHEDULE_LIMIT | NUMBER | |||
END_CUSTOMER | VARCHAR2 | (240) | ||
END_CUSTOMER_LOCATION | VARCHAR2 | (240) | ||
EXPIRATION_DATE | DATE | |||
FOB_POINT_CODE | VARCHAR2 | (240) | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | (240) | ||
FREIGHT_TERMS | VARCHAR2 | (240) | ||
CURRENT_LOCATION | VARCHAR2 | (240) | ||
INSTALLED_AT_LOCATION | VARCHAR2 | (240) | ||
OWNER | VARCHAR2 | (240) | ||
INVOICE_TO | VARCHAR2 | (240) | ||
INVOICING_RULE | VARCHAR2 | (240) | ||
ITEM_IDENTIFIER_TYPE | VARCHAR2 | (240) | ||
ITEM_REVISION | NUMBER | |||
LATEST_ACCEPTABLE_DATE | DATE | |||
LATEST_SCHEDULE_LIMIT | NUMBER | |||
LINE_TYPE | VARCHAR2 | (240) | ||
PRICING_AGREEMENT | VARCHAR2 | (240) | ||
CREDIT_CARD_TYPE | VARCHAR2 | (240) | ||
END_CUSTOMER_ACCOUNT | VARCHAR2 | (240) | ||
FOB | VARCHAR2 | (240) | ||
BILL_TO_CUSTOMER_ACCOUNT | VARCHAR2 | (240) | ||
BILL_TO_CUSTOMER | VARCHAR2 | (240) | ||
PAYMENT_TERMS | VARCHAR2 | (240) | ||
PAYMENT_TYPE | VARCHAR2 | (240) | ||
CHARGE_PERIODICITY | VARCHAR2 | (240) | ||
PRICE_LIST | VARCHAR2 | (240) | ||
SHIPMENT_PRIORITY | VARCHAR2 | (240) | ||
WAREHOUSE | VARCHAR2 | (240) | ||
SHIPPING_METHOD | VARCHAR2 | (240) | ||
SHIP_TO_CUSTOMER_ACCOUNT | VARCHAR2 | (240) | ||
SHIP_TO_CUSTOMER | VARCHAR2 | (240) | ||
ORDERED_DATE | DATE | |||
ORDERED_QUANTITY | NUMBER | |||
ORDER_DATE_TYPE | VARCHAR2 | (240) | ||
UOM | VARCHAR2 | (240) | ||
ORDER_TYPE | VARCHAR2 | (240) | ||
AUTOMATIC_PRICING | VARCHAR2 | (240) | ||
AUTOMATIC_TAX | VARCHAR2 | (240) | ||
CONTRACT_TEMPLATE | VARCHAR2 | (240) | ||
CURRENCY | VARCHAR2 | (240) | ||
QUOTE_TO_CUSTOMER_ACCOUNT | VARCHAR2 | (240) | ||
SOURCE_NAME | VARCHAR2 | (240) | ||
OPERATING_UNIT | VARCHAR2 | (240) | ||
QUOTE_NAME | VARCHAR2 | (240) | ||
REQUESTED_DATE_TYPE | VARCHAR2 | (240) | ||
PRIMARY_SALESGROUP | VARCHAR2 | (240) | ||
PRIMARY_SALESPERSON | VARCHAR2 | (240) | ||
SALES_CHANNEL | VARCHAR2 | (240) | ||
PACKING_INSTRUCTIONS | VARCHAR2 | (240) | ||
PAYMENT_COLLECTION_EVENT | VARCHAR2 | (240) | ||
PAYMENT_TERM | VARCHAR2 | (240) | ||
PAYMENT_TRX | NUMBER | |||
PRICING_DATE | DATE | |||
PROFILE_OPTION | VARCHAR2 | (30) | ||
PROMISE_DATE | DATE | |||
QUOTE_DATE | DATE | |||
RECEIPT_METHOD | VARCHAR2 | (240) | ||
RELATED_OBJECT | VARCHAR2 | (30) | ||
RELATED_ATTRIBUTE | VARCHAR2 | (30) | ||
REQUEST_DATE | DATE | |||
SALEPERSON | VARCHAR2 | (240) | ||
ATTRIBUTE | VARCHAR2 | (30) | ||
SCHEDULE_ARRIVAL_DATE | DATE | |||
SCHEDULE_SHIP_DATE | DATE | |||
SEQUENCE | VARCHAR2 | (30) | ||
SERVICE_DURATION | NUMBER | |||
SERVICE_PERIOD | VARCHAR2 | (240) | ||
SHIPMENT_PRIORITY_CODE | VARCHAR2 | (240) | ||
SHIPPING_INSTRUCTIONS | VARCHAR2 | (240) | ||
SHIP_TOLERANCE_ABOVE | NUMBER | |||
SHIP_TOLERANCE_BELOW | NUMBER | |||
SHIP_TO | VARCHAR2 | (240) | ||
SOLD_TO | VARCHAR2 | (240) | ||
SOURCETYPE | VARCHAR2 | (240) | ||
SUBINVENTORY | VARCHAR2 | (240) | ||
SYSTEM_EXPRESSION | VARCHAR2 | (255) | ||
TAX_CLASSIFICATION_CODE | VARCHAR2 | (240) | ||
TAX_DATE | DATE | |||
TAX_HANDLING | VARCHAR2 | (240) | ||
TAX_EXEMPT_NUMBER | VARCHAR2 | (240) | ||
TAX_EXEMPT_REASON | VARCHAR2 | (240) | ||
TRANSACTION_PHASE | VARCHAR2 | (240) | ||
UNIT_OF_MEASURE | VARCHAR2 | (240) | ||
USER_STATUS | VARCHAR2 | (240) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (2124) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SOURCE_TYPE
, ACCOUNTING_RULE
, AGREEMENT
, PACKAGE_NAME
, FUNCTION_NAME
, ATTRIBUTE1
, ATTRIBUTE2
, CALCULATE_PRICE
, CHECK_NUMBER
, VALUE
, CONVERSION_RATE_DATE
, CONVERSION_TYPE
, CUSTOMER_PO
, DEFAULT_FULFILLMENT_SET
, DEFAULT_LINE_SET
, DELIVERY_LEAD_TIME
, DELIVER_TO
, DEMAND_CLASS
, DEPARTURE_PLANNING_REQUIRED
, EARLIEST_ACCEPTABLE_DATE
, EARLIEST_SCHEDULE_LIMIT
, END_CUSTOMER
, END_CUSTOMER_LOCATION
, EXPIRATION_DATE
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS
, CURRENT_LOCATION
, INSTALLED_AT_LOCATION
, OWNER
, INVOICE_TO
, INVOICING_RULE
, ITEM_IDENTIFIER_TYPE
, ITEM_REVISION
, LATEST_ACCEPTABLE_DATE
, LATEST_SCHEDULE_LIMIT
, LINE_TYPE
, PRICING_AGREEMENT
, CREDIT_CARD_TYPE
, END_CUSTOMER_ACCOUNT
, FOB
, BILL_TO_CUSTOMER_ACCOUNT
, BILL_TO_CUSTOMER
, PAYMENT_TERMS
, PAYMENT_TYPE
, CHARGE_PERIODICITY
, PRICE_LIST
, SHIPMENT_PRIORITY
, WAREHOUSE
, SHIPPING_METHOD
, SHIP_TO_CUSTOMER_ACCOUNT
, SHIP_TO_CUSTOMER
, ORDERED_DATE
, ORDERED_QUANTITY
, ORDER_DATE_TYPE
, UOM
, ORDER_TYPE
, AUTOMATIC_PRICING
, AUTOMATIC_TAX
, CONTRACT_TEMPLATE
, CURRENCY
, QUOTE_TO_CUSTOMER_ACCOUNT
, SOURCE_NAME
, OPERATING_UNIT
, QUOTE_NAME
, REQUESTED_DATE_TYPE
, PRIMARY_SALESGROUP
, PRIMARY_SALESPERSON
, SALES_CHANNEL
, PACKING_INSTRUCTIONS
, PAYMENT_COLLECTION_EVENT
, PAYMENT_TERM
, PAYMENT_TRX
, PRICING_DATE
, PROFILE_OPTION
, PROMISE_DATE
, QUOTE_DATE
, RECEIPT_METHOD
, RELATED_OBJECT
, RELATED_ATTRIBUTE
, REQUEST_DATE
, SALEPERSON
, ATTRIBUTE
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, SEQUENCE
, SERVICE_DURATION
, SERVICE_PERIOD
, SHIPMENT_PRIORITY_CODE
, SHIPPING_INSTRUCTIONS
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, SHIP_TO
, SOLD_TO
, SOURCETYPE
, SUBINVENTORY
, SYSTEM_EXPRESSION
, TAX_CLASSIFICATION_CODE
, TAX_DATE
, TAX_HANDLING
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON
, TRANSACTION_PHASE
, UNIT_OF_MEASURE
, USER_STATUS
, CONCATENATED_SEGMENTS
FROM APPS.OE_DEF_ATTR_DEF_RULES_DFV;
APPS.OE_DEF_ATTR_DEF_RULES_DFV is not referenced by any database object
|
|
|