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

TABLE: OKC.OKC_PH_LINE_BREAKS

Object Details
Object Name: OKC_PH_LINE_BREAKS
Object Type: TABLE
Owner: OKC
FND Design Data: TableOKC.OKC_PH_LINE_BREAKS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes Primary key - Not Used
CLE_ID NUMBER
Yes Foreign key to OKC_K_LINES_B where line style is Price Hold - Not Used
VALUE_FROM NUMBER
Yes Lower range of the price break - Not Used
VALUE_TO NUMBER

Higher range of the price break - Not Used
PRICING_TYPE VARCHAR2 (30) Yes Foreign key to FND_LOOKUPS.LOOKUP_TYPE where lookup type will be 'OKC_PH_PRICE_TYPE' - Not Used
VALUE NUMBER
Yes Value of discount percent, discount amount or new price - Not Used
START_DATE DATE

Start date of the line break - Not Used
END_DATE DATE

End date of the line break - Not Used
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number - Not Used
CREATED_BY NUMBER
Yes Standard WHO column - Not Used
CREATION_DATE DATE
Yes Standard WHO column - Not Used
LAST_UPDATED_BY NUMBER
Yes Standard WHO column - Not Used
LAST_UPDATE_DATE DATE
Yes Standard Who Column - Not Used
PROGRAM_APPLICATION_ID NUMBER

Standard WHO column - Not Used
PROGRAM_ID NUMBER

Standard WHO column - Not Used
PROGRAM_UPDATE_DATE DATE

Standard WHO column - Not Used
REQUEST_ID NUMBER

Standard WHO column - Not Used
SECURITY_GROUP_ID NUMBER

Used for hosting - Not Used
INTEGRATED_WITH_QP VARCHAR2 (1)
Flag to indicate whether price break line is integrated with QP - Not Used
QP_REFERENCE_ID NUMBER

Reference to QP - Not Used
SHIP_TO_ORGANIZATION_ID NUMBER

Unique identifier for the ship-to organization - Not Used
SHIP_TO_LOCATION_ID NUMBER

Unique identifier for the ship-to location - Not Used
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column - Not Used
Query Text

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


SELECT ID
,      CLE_ID
,      VALUE_FROM
,      VALUE_TO
,      PRICING_TYPE
,      VALUE
,      START_DATE
,      END_DATE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      SECURITY_GROUP_ID
,      INTEGRATED_WITH_QP
,      QP_REFERENCE_ID
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_LOCATION_ID
,      LAST_UPDATE_LOGIN
FROM OKC.OKC_PH_LINE_BREAKS;

Dependencies

[top of page]

OKC.OKC_PH_LINE_BREAKS does not reference any database object

OKC.OKC_PH_LINE_BREAKS is referenced by following:

SchemaAPPS
SynonymOKC_PH_LINE_BREAKS