APPS.OKC_XPRT_QUOTE_INT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 98

select a.FLEX_VALUE_ID
from fnd_flex_values a, fnd_flex_value_sets b
where b.flex_value_set_name = 'OKC_XPRT_YES_NO'
and a.FLEX_VALUE_SET_ID = b.FLEX_VALUE_SET_ID
and a.FLEX_VALUE = p_yes_no;

Line: 109

SELECT
      quote.cust_account_id,
      quote.currency_code,
      quote.contract_id price_agreement_id,
--      decode(nvl(to_char(quote.contract_id),'X'),'X','N','Y') price_agreement_exist,
      decode(nvl(to_char(quote.contract_id),'X'),'X',l_expert_no,l_expert_yes) price_agreement_exist,
      quote.total_adjusted_percent,
      quote.total_adjusted_amount,
      quote.total_quote_price,
      quote.order_type_id,
      quote.party_id,
      quote.invoice_to_cust_account_id,
      quote.invoice_to_party_site_id,
      quote.sold_to_party_site_id,
      quote.price_list_id,
      quote.sales_channel_code,
--      decode(nvl(payments.cust_po_number,'X'),'X','N','Y') cust_po_num_exist,
      decode(nvl(payments.cust_po_number,'X'),'X',l_expert_no,l_expert_yes) cust_po_num_exist,
      payments.payment_term_id,
      payments.payment_type_code,
      nvl(tax.tax_exempt_flag,'S') tax_exempt_flag,
      shipments.freight_terms_code,
      shipments.ship_method_code,
      shipments.fob_code,
      shipments.ship_to_cust_account_id,
      shipments.ship_to_party_site_id,
-- XY
	 quote.quote_number,
--	 quote.cust_party_id,
	 quote.quote_version,
	 quote.resource_id,
	 quote.org_id,
	 payments.cust_po_number,
	 shipments.shipment_priority_code,
	 quote.minisite_id
-- XY
FROM
      aso_payments payments,
      aso_tax_details tax,
      aso_shipments shipments,
      aso_quote_headers_all quote
WHERE
      quote.quote_header_id = payments.quote_header_id(+)
 AND  payments.quote_line_id(+) IS NULL
 AND  quote.quote_header_id = tax.quote_header_id(+)
 AND  tax.quote_line_id(+) IS NULL
 AND  quote.quote_header_id = shipments.quote_header_id(+)
 AND  shipments.quote_line_id(+) IS NULL
 AND  quote.quote_header_id = p_doc_id;

Line: 165

SELECT
     hzp.category_code,
	hzp.party_id,
	hzc.customer_class_code,
	hzcp.profile_class_id,
	hzcp.credit_rating,
	hzcp.credit_classification,
	hzcp.risk_code
FROM
     hz_customer_profiles hzcp,
     hz_cust_accounts hzc,
     hz_parties hzp
WHERE
     hzc.cust_account_id = hzcp.cust_account_id
AND  hzcp.site_use_id is null
AND  hzc.party_id = hzcp.party_id
AND  hzc.party_id = hzp.party_id
AND  hzc.cust_account_id = p_sold_to_org_id;

Line: 191

SELECT
     loc.country
FROM
     hz_locations loc,
     hz_party_sites ps
WHERE
     ps.location_id = loc.location_id
AND  ps.party_site_id = p_party_site_id;

Line: 206

 SELECT
     pc.agreement_type_code
 FROM
     --oe_pricing_contracts_v pc -- Commented for Perf Bug 5027295
     oe_agreements_b pc          -- Added for Perf Bug 5027295
 WHERE
     pc.agreement_id = p_agreement_id;

Line: 332

	      SELECT category_code
		 INTO l_customer_category
		 FROM hz_parties
		 WHERE party_id = l_quote_header_variables.party_id;

Line: 702

	      SELECT
		    items.concatenated_segments
           BULK COLLECT INTO x_line_var_value_tbl.item
           FROM
		    Mtl_System_Items_vl items,
		    Aso_Quote_Lines_all lines
           WHERE
	         lines.inventory_item_id = items.INVENTORY_ITEM_ID
             AND lines.organization_id = items.organization_id
             AND lines.LINE_CATEGORY_CODE = 'ORDER'
             AND lines.quote_header_id = p_doc_id;

Line: 719

	      SELECT
		      cats.category_concat_segs
           BULK COLLECT INTO x_line_var_value_tbl.category
        	 FROM
		    Mtl_Item_Categories mic,
		    Aso_Quote_Lines_all lines,
		    Mtl_Categories_V cats
        	 WHERE
		    lines.inventory_item_id = mic.INVENTORY_ITEM_ID
             AND mic.category_id = cats.category_id
             AND mic.organization_id = lines.organization_id
             AND mic.category_set_id = (
					SELECT nvl(FND_PROFILE.VALUE('ASO_CATEGORY_SET'), sets.category_set_id )
              			FROM Mtl_Default_Category_Sets sets
              			WHERE functional_area_id = 7
				     )
             AND lines.LINE_CATEGORY_CODE = 'ORDER'
         	   AND lines.quote_header_id = p_doc_id;

Line: 832

SELECT
      quote.quote_line_id,
      ASO_LINE_NUM_INT.Get_UI_Line_Number(quote.quote_line_id) line_number, -- Changed for Bug 4768964
      nvl(payments.payment_term_id,'-99999') payment_term_id,
      nvl(shipments.fob_code,'NO_VALUE') fob_code,
      quote.inventory_item_id,
      quote.org_id
FROM
      aso_payments payments,
      aso_shipments shipments,
      aso_quote_lines_all quote
WHERE
      quote.quote_line_id = payments.quote_line_id(+)
 AND  quote.quote_line_id = shipments.quote_line_id(+)
 AND  quote.quote_header_id = p_doc_id;

Line: 855

SELECT
    items.concatenated_segments item
FROM
    Mtl_System_Items_vl items,
    Aso_Quote_Lines_all lines
WHERE
 lines.inventory_item_id = items.INVENTORY_ITEM_ID
AND lines.organization_id = items.organization_id
--AND lines.LINE_CATEGORY_CODE = 'ORDER'
AND lines.quote_header_id = p_doc_id
AND lines.quote_line_id = p_quote_line_id;

Line: 868

SELECT
      cats.category_concat_segs item_category
 FROM
    Mtl_Item_Categories mic,
    Aso_Quote_Lines_all lines,
    Mtl_Categories_V cats
 WHERE
    lines.inventory_item_id = mic.INVENTORY_ITEM_ID
AND mic.category_id = cats.category_id
AND mic.organization_id = lines.organization_id
AND mic.category_set_id = (
			SELECT nvl(FND_PROFILE.VALUE('ASO_CATEGORY_SET'), sets.category_set_id )
		FROM Mtl_Default_Category_Sets sets
		WHERE functional_area_id = 7
		     )
AND lines.LINE_CATEGORY_CODE = 'ORDER'
AND lines.quote_header_id = p_doc_id
AND lines.quote_line_id = p_quote_line_id;

Line: 895

SELECT
      quote.org_id
FROM
      aso_quote_headers_all quote
WHERE
      quote.quote_header_id = p_doc_id;