Table level details of the record after data flows to OSC from CPQ
Summary
Table level details of the record after data flows to OSC from CPQContent
Section-1)
Please use this example only
SELECT distinct pp.person_name,
p.party_name,
h_contact.party_name AS CONTACT_NAME,
M.NAME,
h1.city,
h.extn_attribute_char003,
TO_CHAR(h.extn_attribute_timestamp001,'DD-MON-YYYY',
'NLS_DATE_LANGUAGE=AMERICAN') AS RECIEVED_DATE,
h.extn_attribute_char004,
h.extn_attribute_char005,
h.extn_attribute_char006,
to_char(h.extn_attribute_timestamp002,'DD-MON-YYYY',
'NLS_DATE_LANGUAGE=AMERICAN') AS BID_QUOTATION_DATE,
h.extn_attribute_char010,
to_char(h.extn_attribute_timestamp003,'DD-MON-YYYY',
'NLS_DATE_LANGUAGE=AMERICAN') AS STATUS_UPDATION_DATE,
2