VIEW: APPS.OKL_AM_QUOTE_PARTY_CONTACTS_UV

Source

View Text - Preformatted

SELECT null QTE_ID, null contract_id, null k_buy_or_sell, null qp_party_id, null qp_role_code, null qp_party_role, null qp_date_sent, null qp_date_hold, null qp_created_by, null qp_creation_date, null qp_last_updated_by, null qp_last_update_date, null qp_last_update_login, null kp_party_id, null kp_role_code, null kp_party_role, null po_party_id1, null po_party_id2, null po_party_object, null po_party_name, null po_party_desc, null co_contact_id1, null co_contact_id2, null co_contact_object, null co_contact_name, null co_contact_desc, null co_email, null co_order_num, null co_date_sent, null cp_point_id, null cp_point_type, null cp_primary_flag, null cp_email, null cp_details, null cp_order_num, null cp_date_sent FROM OKL_AM_QUOTE_PARTIES_UV OAV WHERE OAV.QUOTE_ID = 0

View Text - HTML Formatted

SELECT NULL QTE_ID
, NULL CONTRACT_ID
, NULL K_BUY_OR_SELL
, NULL QP_PARTY_ID
, NULL QP_ROLE_CODE
, NULL QP_PARTY_ROLE
, NULL QP_DATE_SENT
, NULL QP_DATE_HOLD
, NULL QP_CREATED_BY
, NULL QP_CREATION_DATE
, NULL QP_LAST_UPDATED_BY
, NULL QP_LAST_UPDATE_DATE
, NULL QP_LAST_UPDATE_LOGIN
, NULL KP_PARTY_ID
, NULL KP_ROLE_CODE
, NULL KP_PARTY_ROLE
, NULL PO_PARTY_ID1
, NULL PO_PARTY_ID2
, NULL PO_PARTY_OBJECT
, NULL PO_PARTY_NAME
, NULL PO_PARTY_DESC
, NULL CO_CONTACT_ID1
, NULL CO_CONTACT_ID2
, NULL CO_CONTACT_OBJECT
, NULL CO_CONTACT_NAME
, NULL CO_CONTACT_DESC
, NULL CO_EMAIL
, NULL CO_ORDER_NUM
, NULL CO_DATE_SENT
, NULL CP_POINT_ID
, NULL CP_POINT_TYPE
, NULL CP_PRIMARY_FLAG
, NULL CP_EMAIL
, NULL CP_DETAILS
, NULL CP_ORDER_NUM
, NULL CP_DATE_SENT
FROM OKL_AM_QUOTE_PARTIES_UV OAV
WHERE OAV.QUOTE_ID = 0