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_CONDN_ELEMS_DFV

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
ATTRIBUTE_CODE	VARCHAR2	(30)	Yes
ACCOUNTING_RULE	VARCHAR2	(255)
AGREEMENT	VARCHAR2	(255)
BOOKED	VARCHAR2	(255)
CANCELLED	VARCHAR2	(255)
CREATED_BY	VARCHAR2	(255)
DEFAULT_LINE_SET	VARCHAR2	(255)
DELIVER_TO	VARCHAR2	(255)
DEMAND_CLASS	VARCHAR2	(255)
DEPARTURE_PLANNING_REQUIRED_FL	VARCHAR2	(255)
DRAFT_SUBMITTED	VARCHAR2	(255)
FOB_POINT_CODE	VARCHAR2	(255)
FREIGHT_CARRIER_CODE	VARCHAR2	(255)
FREIGHT_TERMS	VARCHAR2	(255)
INTERNAL_ITEM	VARCHAR2	(255)
INVOICE_TO	VARCHAR2	(255)
INVOICING_RULE	VARCHAR2	(255)
ITEM_TYPE	VARCHAR2	(255)
LINE_CATEGORY	VARCHAR2	(255)
LINE_TYPE	VARCHAR2	(255)
PRICING_AGREEMENT	VARCHAR2	(255)
END_CUSTOMER_ACCOUNT	VARCHAR2	(255)
END_CUSTOMER	VARCHAR2	(255)
FOB	VARCHAR2	(255)
PRODUCT	VARCHAR2	(255)
BILL_TO_CUSTOMER_ACCOUNT	VARCHAR2	(255)
BILL_TO_CUSTOMER	VARCHAR2	(255)
OPERATING_UNIT	VARCHAR2	(255)
PAYMENT_TERMS	VARCHAR2	(255)
PAYMENT_TYPE	VARCHAR2	(255)
CHARGE_PERIODICITY	VARCHAR2	(255)
PRICE_LIST	VARCHAR2	(255)
QUOTE_TO_CUSTOMER_TYPE	VARCHAR2	(255)
REQUEST_DATE	VARCHAR2	(255)
SHIPMENT_PRIORITY	VARCHAR2	(255)
WAREHOUSE	VARCHAR2	(255)
SHIPPING_METHOD	VARCHAR2	(255)
SHIP_TO_CUSTOMER_ACCOUNT	VARCHAR2	(255)
SHIP_TO_CUSTOMER	VARCHAR2	(255)
OPEN	VARCHAR2	(255)
ORDERED_DATE	DATE
ORDER_CATEGORY	VARCHAR2	(255)
ORDER_DATE_TYPE	VARCHAR2	(255)
ORDER_SOURCE	VARCHAR2	(255)
ORDER_TYPE	VARCHAR2	(255)
ORG	VARCHAR2	(255)
CURRENCY	VARCHAR2	(255)
QUOTE_TO_CUSTOMER_ACCOUNT	VARCHAR2	(255)
OPPORTUNITY_CUSTOMER	VARCHAR2	(255)
REQUESTED_DATE_TYPE	VARCHAR2	(255)
PRIMARY_SALESPERSON	VARCHAR2	(255)
PARTY_TYPE	VARCHAR2	(255)
PAYMENT_COLLECTION_EVENT	VARCHAR2	(255)
PAYMENT_TYPES	VARCHAR2	(255)
PERCENT	NUMBER
GRADE	VARCHAR2	(255)
PRICING_CONTEXT	VARCHAR2	(255)
PROMISE_DATE	DATE
QUALIFIER_CONTEXT	VARCHAR2	(255)
QUOTE_TO_CUSTOMER	VARCHAR2	(255)
RETROBILL_REQUEST	NUMBER
SALEPERSON	VARCHAR2	(255)
SALES_CHANNEL	VARCHAR2	(255)
SALES_CREDIT_TYPE	VARCHAR2	(255)
SCHEDULE_ARRIVAL_DATE	DATE
SCHEDULE_SHIP_DATE	DATE
SHIPPING_INSTRUCTIONS	VARCHAR2	(255)
SHIP_TOLERANCE_ABOVE	NUMBER
SHIP_TOLERANCE_BELOW	NUMBER
SHIP_TO	VARCHAR2	(255)
SOLD_TO	VARCHAR2	(255)
SOURCE_DOCUMENT_TYPE	VARCHAR2	(255)
SOURCE_TYPE	VARCHAR2	(255)
SRC_SYSTEM_CODE	VARCHAR2	(255)
TAX_CLASSIFICATION_CODE	VARCHAR2	(255)
TAX_DATE	DATE
TAX_HANDLING	VARCHAR2	(255)
TAX_EXEMPT_NUMBER	VARCHAR2	(255)
TAX_EXEMPT_REASON	VARCHAR2	(255)
TRANSACTION_PHASE	VARCHAR2	(255)
UNIT_OF_MEASURE	VARCHAR2	(255)
CONCATENATED_SEGMENTS	VARCHAR2	(286)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ATTRIBUTE_CODE
,      ACCOUNTING_RULE
,      AGREEMENT
,      BOOKED
,      CANCELLED
,      CREATED_BY
,      DEFAULT_LINE_SET
,      DELIVER_TO
,      DEMAND_CLASS
,      DEPARTURE_PLANNING_REQUIRED_FL
,      DRAFT_SUBMITTED
,      FOB_POINT_CODE
,      FREIGHT_CARRIER_CODE
,      FREIGHT_TERMS
,      INTERNAL_ITEM
,      INVOICE_TO
,      INVOICING_RULE
,      ITEM_TYPE
,      LINE_CATEGORY
,      LINE_TYPE
,      PRICING_AGREEMENT
,      END_CUSTOMER_ACCOUNT
,      END_CUSTOMER
,      FOB
,      PRODUCT
,      BILL_TO_CUSTOMER_ACCOUNT
,      BILL_TO_CUSTOMER
,      OPERATING_UNIT
,      PAYMENT_TERMS
,      PAYMENT_TYPE
,      CHARGE_PERIODICITY
,      PRICE_LIST
,      QUOTE_TO_CUSTOMER_TYPE
,      REQUEST_DATE
,      SHIPMENT_PRIORITY
,      WAREHOUSE
,      SHIPPING_METHOD
,      SHIP_TO_CUSTOMER_ACCOUNT
,      SHIP_TO_CUSTOMER
,      OPEN
,      ORDERED_DATE
,      ORDER_CATEGORY
,      ORDER_DATE_TYPE
,      ORDER_SOURCE
,      ORDER_TYPE
,      ORG
,      CURRENCY
,      QUOTE_TO_CUSTOMER_ACCOUNT
,      OPPORTUNITY_CUSTOMER
,      REQUESTED_DATE_TYPE
,      PRIMARY_SALESPERSON
,      PARTY_TYPE
,      PAYMENT_COLLECTION_EVENT
,      PAYMENT_TYPES
,      PERCENT
,      GRADE
,      PRICING_CONTEXT
,      PROMISE_DATE
,      QUALIFIER_CONTEXT
,      QUOTE_TO_CUSTOMER
,      RETROBILL_REQUEST
,      SALEPERSON
,      SALES_CHANNEL
,      SALES_CREDIT_TYPE
,      SCHEDULE_ARRIVAL_DATE
,      SCHEDULE_SHIP_DATE
,      SHIPPING_INSTRUCTIONS
,      SHIP_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      SHIP_TO
,      SOLD_TO
,      SOURCE_DOCUMENT_TYPE
,      SOURCE_TYPE
,      SRC_SYSTEM_CODE
,      TAX_CLASSIFICATION_CODE
,      TAX_DATE
,      TAX_HANDLING
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON
,      TRANSACTION_PHASE
,      UNIT_OF_MEASURE
,      CONCATENATED_SEGMENTS
FROM APPS.OE_DEF_CONDN_ELEMS_DFV;

Dependencies

[top of page]

APPS.OE_DEF_CONDN_ELEMS_DFV references the following:

APPS: FND_NUMBER - show dependent code; OE_DEF_CONDN_ELEMS

APPS.OE_DEF_CONDN_ELEMS_DFV is not referenced by any database object