DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OE_PC_VTMPLT_COLS_DFV

Object Details
Object Name: OE_PC_VTMPLT_COLS_DFV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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;

Dependencies

[top of page]

APPS.OE_PC_VTMPLT_COLS_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymOE_PC_VTMPLT_COLS

APPS.OE_PC_VTMPLT_COLS_DFV is not referenced by any database object