VIEW: APPS.OKL_QUOTE_PARTIES_V

Source

View Text - Preformatted

SELECT QPYB.rowid ROW_ID ,QPYB.ID ID ,QPYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER ,QPYB.QTE_ID QTE_ID ,QPYB.CPL_ID CPL_ID ,QPYB.DATE_SENT DATE_SENT ,QPYB.QPT_CODE QPT_CODE ,QPYB.DELAY_DAYS DELAY_DAYS ,QPYB.ALLOCATION_PERCENTAGE ALLOCATION_PERCENTAGE ,QPYB.EMAIL_ADDRESS EMAIL_ADDRESS ,QPYB.PARTY_JTOT_OBJECT1_CODE PARTY_JTOT_OBJECT1_CODE ,QPYB.PARTY_OBJECT1_ID1 PARTY_OBJECT1_ID1 ,QPYB.PARTY_OBJECT1_ID2 PARTY_OBJECT1_ID2 ,QPYB.CONTACT_JTOT_OBJECT1_CODE CONTACT_JTOT_OBJECT1_CODE ,QPYB.CONTACT_OBJECT1_ID1 CONTACT_OBJECT1_ID1 ,QPYB.CONTACT_OBJECT1_ID2 CONTACT_OBJECT1_ID2 ,QPYB.CREATED_BY CREATED_BY ,QPYB.CREATION_DATE CREATION_DATE ,QPYB.LAST_UPDATED_BY LAST_UPDATED_BY ,QPYB.LAST_UPDATE_DATE LAST_UPDATE_DATE ,QPYB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM OKL_QUOTE_PARTIES QPYB

View Text - HTML Formatted

SELECT QPYB.ROWID ROW_ID
, QPYB.ID ID
, QPYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, QPYB.QTE_ID QTE_ID
, QPYB.CPL_ID CPL_ID
, QPYB.DATE_SENT DATE_SENT
, QPYB.QPT_CODE QPT_CODE
, QPYB.DELAY_DAYS DELAY_DAYS
, QPYB.ALLOCATION_PERCENTAGE ALLOCATION_PERCENTAGE
, QPYB.EMAIL_ADDRESS EMAIL_ADDRESS
, QPYB.PARTY_JTOT_OBJECT1_CODE PARTY_JTOT_OBJECT1_CODE
, QPYB.PARTY_OBJECT1_ID1 PARTY_OBJECT1_ID1
, QPYB.PARTY_OBJECT1_ID2 PARTY_OBJECT1_ID2
, QPYB.CONTACT_JTOT_OBJECT1_CODE CONTACT_JTOT_OBJECT1_CODE
, QPYB.CONTACT_OBJECT1_ID1 CONTACT_OBJECT1_ID1
, QPYB.CONTACT_OBJECT1_ID2 CONTACT_OBJECT1_ID2
, QPYB.CREATED_BY CREATED_BY
, QPYB.CREATION_DATE CREATION_DATE
, QPYB.LAST_UPDATED_BY LAST_UPDATED_BY
, QPYB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QPYB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_QUOTE_PARTIES QPYB