eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OE_DEF_ATTR_DEF_RULES_DFV

Object Details

Object Name:	OE_DEF_ATTR_DEF_RULES_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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;

Dependencies

[top of page]

APPS.OE_DEF_ATTR_DEF_RULES_DFV references the following:

APPS: FND_NUMBER - show dependent code; OE_DEF_ATTR_DEF_RULES

APPS.OE_DEF_ATTR_DEF_RULES_DFV is not referenced by any database object