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.QP_ATTRIBUTE_DEFNS1_DFV

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
GSA	VARCHAR2	(240)
AGREEMENT_NAME	VARCHAR2	(240)
AGREEMENT_TYPE	VARCHAR2	(240)
SHIP_TO	VARCHAR2	(240)
SOLD_TO_ORG_ID	VARCHAR2	(240)
SITE_ORG_ID	VARCHAR2	(240)
BILL_TO	VARCHAR2	(240)
CUSTOMER_CLASS_CODE	VARCHAR2	(240)
SALES_CHANNEL	VARCHAR2	(240)
ACCOUNT_TYPE	VARCHAR2	(240)
PARTY_ID	VARCHAR2	(240)
SHIP_TO_PARTY_SITE_ID	VARCHAR2	(240)
INVOICE_TO_PARTY_SITE_ID	VARCHAR2	(240)
LISTS	VARCHAR2	(240)
SEGMENTS	VARCHAR2	(240)
BUYING_GROUPS	VARCHAR2	(240)
SHIPPING_ORGANIZATION_ID	VARCHAR2	(240)
SELLING_ORGANIZATION_ID	VARCHAR2	(240)
CUSTOMER_ID	VARCHAR2	(240)
CUSTOMER_SITE_ID	VARCHAR2	(240)
CONTRACT_REFERENCE	VARCHAR2	(240)
SUPPLIER	VARCHAR2	(240)
ORIGIN	VARCHAR2	(240)
DESTINATION	VARCHAR2	(240)
MODE_OF_TRANSPORTATION	VARCHAR2	(240)
ADDITIONAL_SERVICE	VARCHAR2	(240)
CONTRACTED_LANE	VARCHAR2	(240)
LIST_LINE_NUMBER	VARCHAR2	(240)
COUPON_NO	VARCHAR2	(240)
PROMOTION_NO	VARCHAR2	(240)
PRICE_LIST	VARCHAR2	(240)
RESTRICTED	VARCHAR2	(240)
ITEM_COST	VARCHAR2	(240)
CUSTOMER_PO	VARCHAR2	(240)
LINE_TYPE	VARCHAR2	(240)
LINE_CATEGORY	VARCHAR2	(240)
ORDER_TYPE	VARCHAR2	(240)
ORDER_CATEGORY	VARCHAR2	(240)
SOURCE_TYPE	VARCHAR2	(240)
ORDER_DATE	DATE
REQUEST_DATE	DATE
PRICING_DATE	DATE
INVENTORY_ORG_ID	VARCHAR2	(240)
SHIPMENT_PRIORITY_CODE	VARCHAR2	(240)
SHIPPABLE_FLAG	VARCHAR2	(240)
SHIPPED_FLAG	VARCHAR2	(240)
FREIGHT_COST_TYPE_CODE	VARCHAR2	(240)
SHIPPED_DATE	DATE
BUYER	VARCHAR2	(240)
SALES_ORGANIZATION	VARCHAR2	(240)
OZF_SALES_METHOD	VARCHAR2	(240)
DISTRIBUTOR	VARCHAR2	(240)
DISTRIBUTOR_LIST	VARCHAR2	(240)
DISTRIBUTOR_SEGMENT	VARCHAR2	(240)
DISTRIBUTOR_TERRITORY	VARCHAR2	(240)
FREIGHT_TERMS	VARCHAR2	(240)
SHIPPING_TERMS	VARCHAR2	(240)
PAYMENT_TERMS	VARCHAR2	(240)
TRADE_MANAGEMENT_TERRITORIES	VARCHAR2	(240)
ORDER_AMOUNT	NUMBER
PERIOD1_ORDER_AMOUNT	NUMBER
PERIOD2_ORDER_AMOUNT	NUMBER
PERIOD3_ORDER_AMOUNT	NUMBER
LINE_WEIGHT	NUMBER
LINE_VOLUME	NUMBER
ORDER_WEIGHT	NUMBER
OREDER_VOLUME	NUMBER
CONCATENATED_SEGMENTS	VARCHAR2	(3645)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      GSA
,      AGREEMENT_NAME
,      AGREEMENT_TYPE
,      SHIP_TO
,      SOLD_TO_ORG_ID
,      SITE_ORG_ID
,      BILL_TO
,      CUSTOMER_CLASS_CODE
,      SALES_CHANNEL
,      ACCOUNT_TYPE
,      PARTY_ID
,      SHIP_TO_PARTY_SITE_ID
,      INVOICE_TO_PARTY_SITE_ID
,      LISTS
,      SEGMENTS
,      BUYING_GROUPS
,      SHIPPING_ORGANIZATION_ID
,      SELLING_ORGANIZATION_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      CONTRACT_REFERENCE
,      SUPPLIER
,      ORIGIN
,      DESTINATION
,      MODE_OF_TRANSPORTATION
,      ADDITIONAL_SERVICE
,      CONTRACTED_LANE
,      LIST_LINE_NUMBER
,      COUPON_NO
,      PROMOTION_NO
,      PRICE_LIST
,      RESTRICTED
,      ITEM_COST
,      CUSTOMER_PO
,      LINE_TYPE
,      LINE_CATEGORY
,      ORDER_TYPE
,      ORDER_CATEGORY
,      SOURCE_TYPE
,      ORDER_DATE
,      REQUEST_DATE
,      PRICING_DATE
,      INVENTORY_ORG_ID
,      SHIPMENT_PRIORITY_CODE
,      SHIPPABLE_FLAG
,      SHIPPED_FLAG
,      FREIGHT_COST_TYPE_CODE
,      SHIPPED_DATE
,      BUYER
,      SALES_ORGANIZATION
,      OZF_SALES_METHOD
,      DISTRIBUTOR
,      DISTRIBUTOR_LIST
,      DISTRIBUTOR_SEGMENT
,      DISTRIBUTOR_TERRITORY
,      FREIGHT_TERMS
,      SHIPPING_TERMS
,      PAYMENT_TERMS
,      TRADE_MANAGEMENT_TERRITORIES
,      ORDER_AMOUNT
,      PERIOD1_ORDER_AMOUNT
,      PERIOD2_ORDER_AMOUNT
,      PERIOD3_ORDER_AMOUNT
,      LINE_WEIGHT
,      LINE_VOLUME
,      ORDER_WEIGHT
,      OREDER_VOLUME
,      CONCATENATED_SEGMENTS
FROM APPS.QP_ATTRIBUTE_DEFNS1_DFV;

Dependencies

[top of page]

APPS.QP_ATTRIBUTE_DEFNS1_DFV references the following:

APPS: FND_NUMBER - show dependent code; QP_ATTRIBUTE_DEFNS

APPS.QP_ATTRIBUTE_DEFNS1_DFV is not referenced by any database object