[Home] [Help] [Dependency Information]
Object Name: | OE_PC_VTMPLT_COLS_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | Yes | |
AGREEMENT_ID | VARCHAR2 | (255) | ||
ATO_LINE | NUMBER | |||
AUTOMATIC_FLAG | VARCHAR2 | (255) | ||
BLANKET_LINE_MAX_AMOUNT | NUMBER | |||
BLANKET_LINE_MIN_AMOUNT | NUMBER | |||
BLANKET_MAX_AMOUNT | NUMBER | |||
BLANKET_MAX_QUANTITY | NUMBER | |||
BLANKET_MIN_AMOUNT | NUMBER | |||
BLANKET_MIN_QUANTITY | NUMBER | |||
BOOKED | VARCHAR2 | (255) | ||
CANCELLED | VARCHAR2 | (255) | ||
CONVERSION_TYPE | VARCHAR2 | (255) | ||
CREATED_BY | VARCHAR2 | (255) | ||
CUSTOMER_SIGNATURE | VARCHAR2 | (255) | ||
CUSTOMER_SIGNATURE_DATE | DATE | |||
DATABASE_FLAG | VARCHAR2 | (255) | ||
DELIVER_TO_ORG_ID | VARCHAR2 | (255) | ||
DEMAND_CLASS | VARCHAR2 | (255) | ||
DRAFT_SUBMITTED | VARCHAR2 | (255) | ||
STATUS | VARCHAR2 | (255) | ||
FOB_POINT_CODE | VARCHAR2 | (255) | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | (255) | ||
FULFILLED | VARCHAR2 | (255) | ||
INVOICED_FLAG | VARCHAR2 | (255) | ||
INVOICE_INTERFACE_STATUS | VARCHAR2 | (255) | ||
ITEM_REVISION | NUMBER | |||
ITEM_TYPE | VARCHAR2 | (255) | ||
LINE_CATEGORY | VARCHAR2 | (255) | ||
LINE_TYPE | VARCHAR2 | (255) | ||
LIST_LINE_TYPE_CODE | VARCHAR2 | (255) | ||
MAX_RELEASE_AMOUNT | NUMBER | |||
MAX_RELEASE_QUANTITY | NUMBER | |||
MIN_RELEASE_AMOUNT | NUMBER | |||
MIN_RELEASE_QUANTITY | NUMBER | |||
DISALLOW_NEW_RELEASES | VARCHAR2 | (255) | ||
OPEN | VARCHAR2 | (255) | ||
ORDERED_DATE | DATE | |||
SECONDARY_UOM | VARCHAR2 | (255) | ||
ORDER_CATEGORY | VARCHAR2 | (255) | ||
UNIT_OF_MEASURE | VARCHAR2 | (255) | ||
ORDER_SOURCE | VARCHAR2 | (255) | ||
ORDER_TYPE | VARCHAR2 | (255) | ||
ORG | VARCHAR2 | (255) | ||
OVERRIDE_AMOUNT | VARCHAR2 | (255) | ||
OVERRIDE_BLANKET_CONTROLS | VARCHAR2 | (255) | ||
OVERRIDE_RELEASE_CONTROLS | VARCHAR2 | (255) | ||
PAYMENT_AMOUNT | NUMBER | |||
PAYMENT_COLLECTION_EVENT | VARCHAR2 | (255) | ||
PAYMENT_SET | NUMBER | |||
PAYMENT_TERM | VARCHAR2 | (255) | ||
PERCENT | NUMBER | |||
PRICE_LIST_ID | VARCHAR2 | (255) | ||
PRICING_DATE | DATE | |||
PRICING_QUANTITY | NUMBER | |||
PROMISE_DATE | DATE | |||
REQUEST_DATE | DATE | |||
SALESPERSON | VARCHAR2 | (255) | ||
SALES_CREDIT_TYPE | VARCHAR2 | (255) | ||
SCHEDULE_ARRIVAL_DATE | DATE | |||
SCHEDULE_SHIP_DATE | DATE | |||
SHIPPED_QUANTITY | NUMBER | |||
SHIPPING_METHOD | VARCHAR2 | (255) | ||
WAREHOUSE | VARCHAR2 | (255) | ||
SHIP_MODEL_COMPLETE | VARCHAR2 | (255) | ||
SHIP_TO_ORG_ID | VARCHAR2 | (255) | ||
SOLD_TO | VARCHAR2 | (255) | ||
SOURCE_DOCUMENT_TYPE | VARCHAR2 | (255) | ||
SOURCE_TYPE | VARCHAR2 | (255) | ||
SUPPLIER_SIGNATURE | VARCHAR2 | (255) | ||
SUPPLIER_SIGNATURE_DATE | DATE | |||
TOP_MODEL_LINE | NUMBER | |||
CURRENCY | VARCHAR2 | (255) | ||
UPGRADE | VARCHAR2 | (255) | ||
USER_STATUS | VARCHAR2 | (255) | ||
SALESREP | VARCHAR2 | (255) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (286) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, AGREEMENT_ID
, ATO_LINE
, AUTOMATIC_FLAG
, BLANKET_LINE_MAX_AMOUNT
, BLANKET_LINE_MIN_AMOUNT
, BLANKET_MAX_AMOUNT
, BLANKET_MAX_QUANTITY
, BLANKET_MIN_AMOUNT
, BLANKET_MIN_QUANTITY
, BOOKED
, CANCELLED
, CONVERSION_TYPE
, CREATED_BY
, CUSTOMER_SIGNATURE
, CUSTOMER_SIGNATURE_DATE
, DATABASE_FLAG
, DELIVER_TO_ORG_ID
, DEMAND_CLASS
, DRAFT_SUBMITTED
, STATUS
, FOB_POINT_CODE
, FREIGHT_CARRIER_CODE
, FULFILLED
, INVOICED_FLAG
, INVOICE_INTERFACE_STATUS
, ITEM_REVISION
, ITEM_TYPE
, LINE_CATEGORY
, LINE_TYPE
, LIST_LINE_TYPE_CODE
, MAX_RELEASE_AMOUNT
, MAX_RELEASE_QUANTITY
, MIN_RELEASE_AMOUNT
, MIN_RELEASE_QUANTITY
, DISALLOW_NEW_RELEASES
, OPEN
, ORDERED_DATE
, SECONDARY_UOM
, ORDER_CATEGORY
, UNIT_OF_MEASURE
, ORDER_SOURCE
, ORDER_TYPE
, ORG
, OVERRIDE_AMOUNT
, OVERRIDE_BLANKET_CONTROLS
, OVERRIDE_RELEASE_CONTROLS
, PAYMENT_AMOUNT
, PAYMENT_COLLECTION_EVENT
, PAYMENT_SET
, PAYMENT_TERM
, PERCENT
, PRICE_LIST_ID
, PRICING_DATE
, PRICING_QUANTITY
, PROMISE_DATE
, REQUEST_DATE
, SALESPERSON
, SALES_CREDIT_TYPE
, SCHEDULE_ARRIVAL_DATE
, SCHEDULE_SHIP_DATE
, SHIPPED_QUANTITY
, SHIPPING_METHOD
, WAREHOUSE
, SHIP_MODEL_COMPLETE
, SHIP_TO_ORG_ID
, SOLD_TO
, SOURCE_DOCUMENT_TYPE
, SOURCE_TYPE
, SUPPLIER_SIGNATURE
, SUPPLIER_SIGNATURE_DATE
, TOP_MODEL_LINE
, CURRENCY
, UPGRADE
, USER_STATUS
, SALESREP
, CONCATENATED_SEGMENTS
FROM APPS.OE_PC_VTMPLT_COLS_DFV;
APPS.OE_PC_VTMPLT_COLS_DFV is not referenced by any database object
|
|
|