[Home] [Help] [Dependency Information]
Object Name: | QP_ATTRIBUTE_DEFNS1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
APPS.QP_ATTRIBUTE_DEFNS1_DFV is not referenced by any database object
|
|
|