[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT msite_name
FROM ibe_msites_vl
where msite_id = p_minisite_id;
SELECT qh.quote_name,
qh.last_update_date,
s.ship_to_cust_account_id,
ip.party_name SHIP_TO_CUST_NAME,
nvl(loc.ADDRESS1,'') add1,
nvl(loc.ADDRESS2,'') add2,
nvl(loc.ADDRESS3,'') add3,
nvl(loc.ADDRESS4,'') add4,
nvl(loc.COUNTRY,'') country,
nvl(loc.CITY,'') city,
nvl(loc.POSTAL_CODE,'') zip,
nvl(loc.STATE,'') state,
nvl(loc.PROVINCE,'') province,
nvl(loc.COUNTY,'') county,
fl.MEANING SHIP_METHOD_CODE_MEANING,
qh.TOTAL_SHIPPING_CHARGE,
qh.TOTAL_TAX,
qh.TOTAL_QUOTE_PRICE
FROM aso_quote_headers_all qh,
aso_shipments s,
hz_party_sites ps,
hz_locations loc,
aso_i_parties_v ip,
wsh_carrier_ship_methods csm,
fnd_lookup_values_vl fl
WHERE qh.quote_header_id = s.quote_header_id
and s.ship_to_party_site_id = ps.party_site_id(+)
and s.ship_to_cust_party_id = ip.party_id(+)
and ps.location_id = loc.location_id(+)
and s.ship_method_code = csm.ship_method_code
and fl.lookup_type = 'SHIP_METHOD'
and fl.lookup_code = csm.ship_method_code
and fl.view_application_id = 3
and qh.quote_header_id = p_quote_header_id
and organization_id = inv_org_id;
SELECT ap.party_name,
ap.person_first_name,
ap.person_last_name,
ap.party_type,
DECODE(ap.party_type, 'PERSON', NULL, ap.party_name) organization_name,
nvl(h.email_address,'') email,
nvl(h.phone_area_code,'') ph_area_code,
nvl(h.phone_number,'') ph_number,
nvl(h.phone_extension,'') ph_extension,
h.phone_line_type ,
h.contact_point_purpose,
h.contact_point_type
FROM hz_contact_points h,
aso_i_parties_v ap,
fnd_user fnd
where fnd.user_id = FND_GLOBAL.USER_ID
and owner_table_name = 'HZ_PARTIES'
and owner_table_id = fnd.customer_id
and fnd.customer_id = ap.party_id
and h.status = 'A';
x_cart_date := rec_get_notify_hdr_tokens.last_update_date;
SELECT qh.quote_header_id,
ql.quote_line_id,
ql.quantity,
ql.line_quote_price,
m.shippable_item_flag,
m.inventory_item_id,
m.description
FROM aso_quote_headers_all qh,
aso_quote_lines_all ql,
mtl_system_items_vl m
where qh.quote_header_id = ql.quote_header_id
and ql.inventory_item_id = m.inventory_item_id
and ql.organization_id = m.organization_id
and qh.quote_header_id = p_quote_header_id;