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 Comments
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)
SUBSCRIPTION_SERVICE 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
,      SUBSCRIPTION_SERVICE
,      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:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymOE_DEF_CONDN_ELEMS

APPS.OE_DEF_CONDN_ELEMS_DFV is not referenced by any database object