APPS.OKS_ENT_UTIL_PVT SQL Statements

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

Line: 29

	SELECT SUM(L.price_negotiated)
	FROM	 OKC_K_LINES_B	 L,
		 OKC_LINE_STYLES_B S
	WHERE	 S.ID = L.LSE_ID
	AND    S.ID IN(7, 8, 9, 10, 11, 18, 25, 35)
	AND	 L.DNZ_CHR_ID = NVL(p_hdr_id, L.DNZ_CHR_ID);

Line: 47

	SELECT P.OBJECT1_ID1
	FROM	 OKC_K_HEADERS_B		 H
		,OKC_K_PARTY_ROLES_B	 P
	WHERE	H.ID			= P.DNZ_CHR_ID
      AND   P.JTOT_OBJECT1_CODE = 'OKX_PARTY'
	AND	H.ID 			= p_hdr_id;

Line: 71

		SELECT RL.OBJECT1_ID1
		FROM	OKC_RULE_GROUPS_B 	RG,
			OKC_RULES_B			RL
		WHERE	RG.dnz_CHR_ID = p_hdr_id
		AND     RG.cle_id Is Null
		AND	RG.ID	= RL.RGP_ID
		AND	RL.JTOT_OBJECT1_CODE = p_inp_type;

Line: 80

		SELECT RL.OBJECT1_ID1
		FROM	OKC_RULE_GROUPS_B 	RG,
			OKC_RULES_B			RL
		WHERE	RG.CLE_ID = p_line_id
		AND	RG.ID	= RL.RGP_ID
		AND	RL.JTOT_OBJECT1_CODE = p_inp_type;

Line: 89

		SELECT  CHR.BILL_TO_SITE_USE_ID,CHR.SHIP_TO_SITE_USE_ID
		FROM	OKC_K_HEADERS_B CHR
		WHERE	CHR.ID = p_hdr_id;

Line: 94

		SELECT  CLE.BILL_TO_SITE_USE_ID,CLE.SHIP_TO_SITE_USE_ID
		FROM	OKC_K_LINES_B CLE
		WHERE	CLE.ID = p_line_id;

Line: 131

	SELECT RL.OBJECT1_ID1, PL.CURRENCY_CODE
	FROM
		OKC_RULE_GROUPS_B		RG,
		OKC_RULES_B			RL,
		OKX_LIST_HEADERS_V	PL
	WHERE
			RG.dnz_CHR_ID		  = p_hdr_id
		AND    	RG.cle_id Is Null
		AND	RG.ID			  = RL.RGP_ID
		AND	RL.OBJECT1_ID1	  = PL.ID1
		AND	RL.OBJECT1_ID2	  = PL.ID2
            AND   RL.JTOT_OBJECT1_CODE = 'OKX_PRICE'
            AND   PL.LIST_TYPE_CODE   = 'PRL';

Line: 146

	SELECT PL.ID1, PL.CURRENCY_CODE
	FROM
		OKC_RULE_GROUPS_B		RG,
		OKC_RULES_B			RL,
		OKX_LIST_HEADERS_V	PL
	WHERE
			RG.CLE_ID		= p_line_id
		AND	RG.ID			  = RL.RGP_ID
		AND	RL.OBJECT1_ID1	  = PL.ID1
		AND	RL.OBJECT1_ID2	  = PL.ID2
            AND   RL.JTOT_OBJECT1_CODE = 'OKX_PRICE'
            AND   PL.LIST_TYPE_CODE   = 'PRL';

Line: 161

		SELECT  CHR.PRICE_LIST_ID,CHR.CURRENCY_CODE
		FROM	OKC_K_HEADERS_B CHR
		WHERE	CHR.ID = p_hdr_id;

Line: 166

		SELECT  CLE.PRICE_LIST_ID,CLE.CURRENCY_CODE
		FROM	OKC_K_LINES_B CLE
		WHERE	CLE.ID = p_line_id;

Line: 205

	SELECT DI.ID1
	FROM
		OKC_RULE_GROUPS_B		RG,
		OKC_RULES_B			RL,
		OKX_LIST_HEADERS_V	DI
	WHERE
			RG.dnz_CHR_ID		  = p_hdr_id
		AND    RG.cle_id Is Null
		AND	RG.ID			  = RL.RGP_ID
		AND	RL.OBJECT1_ID1	  = DI.ID1
		AND	RL.OBJECT1_ID2	  = DI.ID2
            AND   RL.JTOT_OBJECT1_CODE = 'OKX_DISCOUNT'
		AND   DI.LIST_TYPE_CODE = 'DTL';

Line: 220

	SELECT DI.ID1
	FROM
		OKC_RULE_GROUPS_B		RG,
		OKC_RULES_B			RL,
		OKX_LIST_HEADERS_V	DI
	WHERE
			RG.CLE_ID		= p_line_id
		AND	RG.ID			  = RL.RGP_ID
		AND	RL.OBJECT1_ID1	  = DI.ID1
		AND	RL.OBJECT1_ID2	  = DI.ID2
            AND   RL.JTOT_OBJECT1_CODE = 'OKX_DISCOUNT'
		AND   DI.LIST_TYPE_CODE = 'DTL';

Line: 236

		SELECT  OKSCLE.DISCOUNT_LIST
		FROM	OKS_K_LINES_B OKSCLE
		WHERE	OKSCLE.CLE_ID = p_line_id;

Line: 270

	SELECT RLS.OBJECT1_ID1
	FROM	OKC_RULE_GROUPS_B		RGP,
		OKC_RULES_B			RLS
	WHERE	RGP.dnz_CHR_ID		    = p_hdr_id
	AND     RGP.cle_id Is Null
	AND	RGP.ID		    = RLS.RGP_ID
      AND   RLS.JTOT_OBJECT1_CODE = 'OKX_ACCTRULE';

Line: 279

	SELECT RLS.OBJECT1_ID1
	FROM	OKC_RULE_GROUPS_B		RGP,
		OKC_RULES_B			RLS
	WHERE	RGP.CLE_ID		= p_line_id
	AND	RGP.ID		   = RLS.RGP_ID
      AND   RLS.JTOT_OBJECT1_CODE = 'OKX_ACCTRULE';

Line: 287

		SELECT  OKSCHR.ACCT_RULE_ID
		FROM	OKS_K_HEADERS_B OKSCHR
		WHERE	OKSCHR.CHR_ID = p_hdr_id;

Line: 292

		SELECT  OKSCLE.ACCT_RULE_ID
		FROM	OKS_K_LINES_B OKSCLE
		WHERE	OKSCLE.CLE_ID = p_line_id;

Line: 323

	SELECT RLS.OBJECT1_ID1
	FROM	OKC_RULE_GROUPS_B		RGP,
		OKC_RULES_B			RLS
	WHERE	RGP.dnz_CHR_ID		    = p_hdr_id
	AND     RGP.cle_id Is Null
	AND	RGP.ID		    = RLS.RGP_ID
      AND   RLS.JTOT_OBJECT1_CODE = 'OKX_INVRULE';

Line: 332

	SELECT RLS.OBJECT1_ID1
	FROM	OKC_RULE_GROUPS_B		RGP,
		OKC_RULES_B			RLS
	WHERE	RGP.CLE_ID		= p_line_id
	AND	RGP.ID		   = RLS.RGP_ID
      AND   RLS.JTOT_OBJECT1_CODE = 'OKX_INVRULE';

Line: 341

		SELECT  CHR.INV_RULE_ID
		FROM	OKC_K_HEADERS_B CHR
		WHERE	CHR.ID = p_hdr_id;

Line: 346

		SELECT  CLE.INV_RULE_ID
		FROM	OKC_K_LINES_B CLE
		WHERE	CLE.ID = p_line_id;

Line: 377

	SELECT RL.RULE_INFORMATION1
	FROM	 OKC_RULE_GROUPS_B	RG,
		 OKC_RULES_B		RL
	WHERE	 RG.dnz_ChR_ID	= p_hdr_id
	AND      RG.cle_id Is Null
	AND	 RG.ID	= RL.RGP_ID
	AND	 RL.RULE_INFORMATION_CATEGORY = 'BPF';

Line: 386

	SELECT RL.RULE_INFORMATION1
	FROM	 OKC_RULE_GROUPS_B	RG,
		 OKC_RULES_B		RL
	WHERE	 RG.Cle_id	= p_line_id
	AND	 RG.ID	= RL.RGP_ID
	AND	 RL.RULE_INFORMATION_CATEGORY = 'BPF';

Line: 394

		SELECT  OKSCHR.BILLING_PROFILE_ID
		FROM	OKS_K_HEADERS_B OKSCHR
		WHERE	OKSCHR.CHR_ID = p_hdr_id;

Line: 430

	SELECT SUBSTR(RL.RULE_INFORMATION2,1,3) 				BF,
		 DECODE(RL.RULE_INFORMATION5, 0, 'ADV', 'ARR')   	BM,
		 TO_NUMBER(RL.RULE_INFORMATION5)				ROD,
		 RL.RULE_INFORMATION3				            FBT,
		 RL.RULE_INFORMATION4				            FBO
	FROM	 OKC_RULE_GROUPS_B	RG,
		 OKC_RULES_B		RL
	WHERE	 RG.dnz_CHR_ID	= p_hdr_id
	AND      RG.cle_id Is Null
	AND	 RG.ID	= RL.RGP_ID
	AND	 RL.RULE_INFORMATION_CATEGORY = 'SBG';

Line: 443

	SELECT SUBSTR(RL.RULE_INFORMATION2,1,3) 				BF,
		 DECODE(RL.RULE_INFORMATION5, 0, 'ADV', 'ARR')   	BM,
		 TO_NUMBER(RL.RULE_INFORMATION5)				ROD,
		 RL.RULE_INFORMATION3				            FBT,
		 RL.RULE_INFORMATION4				            FBO
	FROM	 OKC_RULE_GROUPS_B	RG,
		 OKC_RULES_B		RL
	WHERE	 RG.Cle_ID	= p_line_id
	AND	 RG.ID	= RL.RGP_ID
	AND	 RL.RULE_INFORMATION_CATEGORY = 'SBG';

Line: 510

	SELECT REN.TEXT
	FROM	 OKC_K_ARTICLES_B	 KAR,
		 OKC_K_ARTICLES_TL REN,
		 FND_LOOKUPS	SBR
	WHERE	KAR.ID            = REN.ID
	AND   REN.SOURCE_LANG   = USERENV('LANG')
	AND   KAR.CHR_ID 		= p_hdr_id
	AND   KAR.CAT_TYPE      = 'NSD'
	AND	SBR.LOOKUP_CODE 	= KAR.SBT_CODE
	AND   SBR.LOOKUP_TYPE	= 'OKC_OPERATION'
	AND   SBR.LOOKUP_CODE	= p_inp_type;

Line: 541

	SELECT RLS.OBJECT1_ID1
	FROM	OKC_RULE_GROUPS_B		RGP,
		OKC_RULES_B			RLS
	WHERE	RGP.dnz_CHR_ID		= p_hdr_id
	AND     RGP.cle_id  Is Null
	AND	RGP.ID		= RLS.RGP_ID
      AND   RLS.JTOT_OBJECT1_CODE = 'OKX_RPAYTERM';

Line: 550

	SELECT RLS.OBJECT1_ID1
	FROM	OKC_RULE_GROUPS_B		RGP,
		OKC_RULES_B			RLS
	WHERE	RGP.Cle_ID		= p_line_id
	AND	RGP.ID		= RLS.RGP_ID
      AND   RLS.JTOT_OBJECT1_CODE = 'OKX_RPAYTERM';

Line: 559

		SELECT  CHR.PAYMENT_TERM_ID
		FROM	OKC_K_HEADERS_B CHR
		WHERE	CHR.ID = p_hdr_id;

Line: 564

		SELECT  CLE.PAYMENT_TERM_ID
		FROM	OKC_K_LINES_B CLE
		WHERE	CLE.ID = p_line_id;

Line: 593

	SELECT PDT.ID1,
		 PDT.QUANTITY
	FROM	 OKC_K_LINES_B			LIN,
		 OKC_K_ITEMS			ITM,
		 OKX_CUSTOMER_PRODUCTS_V	PDT
	WHERE	 LIN.ID		= ITM.CLE_ID
	AND	 ITM.OBJECT1_ID1	= PDT.ID1
	AND	 ITM.OBJECT1_ID2	= PDT.ID2
      AND    ITM.JTOT_OBJECT1_CODE = 'OKX_CUSTPROD'
	AND	 LIN.ID		= p_line_id;

Line: 621

	SELECT PDT.ID1,
		 PDT.CUSTOMER_ID,
		 CUS.NAME,
		 PDT.INSTALL_SITE_USE_ID,
		 SIT.NAME PARTY_SITE_NAME
	FROM	 OKC_K_LINES_B			LIN,
		 OKC_K_ITEMS			ITM,
		 OKX_CUSTOMER_PRODUCTS_V	PDT,
		 OKX_CUSTOMER_ACCOUNTS_V	CUS,
             OKX_PARTIES_V                PTY,
		 OKX_PARTY_SITES_V		SIT --OKX_PARTY_SITE_USES_V		SIT
	WHERE	 LIN.ID		    = ITM.CLE_ID
	AND	 ITM.OBJECT1_ID1	    = PDT.ID1
	AND	 ITM.OBJECT1_ID2	    = PDT.ID2
	AND	 PDT.CUSTOMER_ID	= CUS.ID1
      AND    PTY.ID1 = CUS.PARTY_ID
	AND	 PDT.INSTALL_SITE_USE_ID = SIT.PARTY_SITE_ID
	AND	 LIN.ID		= p_line_id;

Line: 640

    	SELECT PDT.instance_id ID1, --PDT.ID1,
		 PDT.owner_party_account_id customer_id, --PDT.CUSTOMER_ID,
		 CUS.NAME cusname,
		 PDT.install_location_id install_location_id, --PDT.INSTALL_SITE_USE_ID,
		 SIT.NAME PARTY_SITE_NAME
	FROM	 OKC_K_LINES_B			LIN,
		 OKC_K_ITEMS			ITM,
		 CSI_ITEM_INSTANCES PDT, --OKX_CUSTOMER_PRODUCTS_V	PDT,
		 OKX_CUSTOMER_ACCOUNTS_V	CUS,
             OKX_PARTIES_V                PTY,
		 OKX_PARTY_SITES_V		SIT --OKX_PARTY_SITE_USES_V
	WHERE	 LIN.ID		    = ITM.CLE_ID
	AND	 ITM.OBJECT1_ID1	    = PDT.Inventory_item_id --PDT.ID1
	AND	 ITM.OBJECT1_ID2	    = PDT.Inv_Master_Organization_Id --PDT.ID2
    and  PDT.owner_party_account_id = CUS.ID1 --	AND	 PDT.CUSTOMER_ID	= CUS.ID1
    AND  PTY.ID1 = CUS.PARTY_ID
	AND	 PDT.install_location_id = SIT.ID1 --PDT.INSTALL_SITE_USE_ID = SIT.PARTY_SITE_ID
	AND	 LIN.ID		= p_line_id;

Line: 694

	SELECT SY.ID1,
		 SY.NAME
	FROM	 OKC_K_HEADERS_B        HD,
             OKC_K_LINES_B		KL,
		 OKC_K_ITEMS		IT,
		 OKX_SYSTEMS_V		SY
	WHERE	 HD.ID            = KL.DNZ_CHR_ID
      AND    KL.ID		= IT.CLE_ID
	AND	 IT.OBJECT1_ID1	= SY.ID1
	AND	 IT.OBJECT1_ID2	= SY.ID2
      AND    IT.JTOT_OBJECT1_CODE = 'OKX_COVSYST'
      AND    KL.ID = p_line_id
      AND    HD.AUTHORING_ORG_ID = p_org_id;

Line: 725

	SELECT SY.ID1,
		 SY.NAME
	FROM	 OKC_K_HEADERS_B        HD,
             OKC_K_LINES_B		KL,
             OKC_K_ITEMS IT,
--		 OKC_RULE_GROUPS_B	RG,
--		 OKC_RULES_B		RL,
		 OKX_SYSTEMS_V		SY
	WHERE	 HD.ID            = KL.DNZ_CHR_ID
--      AND    KL.ID		= RG.CLE_ID
--	AND	 RG.ID		= RL.RGP_ID
	AND	 IT.OBJECT1_ID1	= SY.ID1
	AND	 IT.OBJECT1_ID2	= SY.ID2
    and  IT.jtot_object1_code = 'OKX_COVSYS'
      AND    HD.AUTHORING_ORG_ID = p_org_id;

Line: 773

	SELECT V.ID1,
		 V.DESCRIPTION
	FROM	 OKC_K_LINES_B		L,
		 OKC_K_ITEMS		I,
		 OKX_SYSTEM_ITEMS_V	V,
             OKC_K_HEADERS_B        H
	WHERE	 L.ID		= I.CLE_ID
	AND	 I.OBJECT1_ID1 = V.ID1
	AND	 I.OBJECT1_ID2 = V.ID2
      AND    I.JTOT_OBJECT1_CODE = 'OKX_COVITEM'
	AND	 L.ID = p_line_id
      AND    H.ID = L.DNZ_CHR_ID
      AND    H.INV_ORGANIZATION_ID = p_organization_id;

Line: 803

	SELECT V.ID1,
		 V.DESCRIPTION
	FROM	 OKC_K_LINES_B		L,
		 OKC_K_ITEMS		I,
		 OKX_SYSTEM_ITEMS_V	V,
             OKC_K_HEADERS_B        H
	WHERE	 L.ID		= I.CLE_ID
	AND	 I.OBJECT1_ID1 = V.ID1
	AND	 I.OBJECT1_ID2 = V.ID2
	AND	 L.ID = p_line_id
      AND    H.ID = L.DNZ_CHR_ID
      AND    H.inv_organization_id = p_organization_id;

Line: 840

	SELECT RQR.RULE_INFORMATION6			DEFAULT_AMCV_FLAG
		,TO_NUMBER(RQR.RULE_INFORMATION5)	DEFAULT_QTY
		,RQR.RULE_INFORMATION11			DEFAULT_UOM
		,TO_NUMBER(RQR.RULE_INFORMATION8)	DEFAULT_DURATION
		,RQR.RULE_INFORMATION2			DEFAULT_PERIOD
		,TO_NUMBER(RQR.RULE_INFORMATION4)	MINIMUM_QTY
		,RQR.RULE_INFORMATION11			MINIMUM_UOM
		,TO_NUMBER(RQR.RULE_INFORMATION8)	MINIMUM_DURATION
		,RQR.RULE_INFORMATION2			MINIMUM_PERIOD
		,TO_NUMBER(RQR.RULE_INFORMATION7)	FIXED_QTY
		,RQR.RULE_INFORMATION11			FIXED_UOM
		,TO_NUMBER(RQR.RULE_INFORMATION8)	FIXED_DURATION
		,RQR.RULE_INFORMATION2			FIXED_PERIOD
		,RQR.RULE_INFORMATION9			LEVEL_FLAG
	FROM	 OKC_K_LINES_B		LIN,
		 OKC_RULE_GROUPS_B	RGP,
		 OKC_RULES_B		RQR
	WHERE	 LIN.ID				 = RGP.CLE_ID
	AND	 RGP.ID				 = RQR.RGP_ID
	AND	 RQR.RULE_INFORMATION_CATEGORY = 'QRE'
	AND	 LIN.ID				 = p_line_id;

Line: 882

   SELECT object1_id1 TAX_EXEMPTION, object2_id1 TAX_STATUS
   FROM   OKC_K_HEADERS_B HD,
          OKC_RULE_GROUPS_B RG,
          OKC_RULES_B RL
   WHERE  HD.ID = RG.DNZ_CHR_ID
   AND    RG.ID = RL.RGP_ID
   AND    RL.RULE_INFORMATION_CATEGORY = 'TAX'
   AND    HD.ID = p_hdr_id;

Line: 893

		SELECT  to_char(OKSCHR.TAX_EXEMPTION_ID),OKSCHR.TAX_STATUS
		FROM	OKS_K_HEADERS_B OKSCHR
		WHERE	OKSCHR.CHR_ID = p_hdr_id;

Line: 921

   SELECT object1_id1
   FROM   OKC_K_HEADERS_B HD,
          OKC_RULE_GROUPS_B RG,
          OKC_RULES_B RL
   WHERE  HD.ID = RG.DNZ_CHR_ID
   AND    RG.ID = RL.RGP_ID
   AND    RL.RULE_INFORMATION_CATEGORY = 'CVN'
   AND    RL.JTOT_OBJECT1_CODE = 'OKX_CONVTYPE'
   AND    HD.ID = p_hdr_id;

Line: 933

		SELECT  CHR.CONVERSION_TYPE
		FROM	OKC_K_HEADERS_B CHR
		WHERE	CHR.ID = p_hdr_id;

Line: 952

   SELECT isa_agreement_id
   FROM   OKC_K_HEADERS_B HD,
          OKC_GOVERNANCES GV
   WHERE  HD.ID = GV.DNZ_CHR_ID
   AND    HD.ID = p_hdr_id;

Line: 973

   SELECT IT.OBJECT1_ID1, PY.NAME
   FROM   OKC_K_LINES_B KL,
          OKC_K_ITEMS IT,
          OKX_PARTIES_V PY
   WHERE  KL.ID = IT.CLE_ID
   AND    IT.OBJECT1_ID1 = PY.ID1
   AND    IT.OBJECT1_ID2 = PY.ID2
   AND    IT.JTOT_OBJECT1_CODE = 'OKX_PARTY'
   AND    KL.ID = p_line_id;

Line: 999

   SELECT IT.OBJECT1_ID1, CT.NAME
   FROM   OKC_K_LINES_B KL,
          OKC_K_ITEMS IT,
          OKX_CUSTOMER_ACCOUNTS_V CT
   WHERE  KL.ID = IT.CLE_ID
   AND    IT.OBJECT1_ID1 = CT.ID1
   AND    IT.OBJECT1_ID2 = CT.ID2
   AND    IT.JTOT_OBJECT1_CODE = 'OKX_CUSTACCT'
   AND    KL.ID = p_line_id;

Line: 1024

   SELECT IT.OBJECT1_ID1, SI.NAME LOCATION
   FROM   OKC_K_LINES_B KL,
          OKC_K_ITEMS IT,
          OKX_CUST_SITE_USES_V SI
   WHERE  KL.ID = IT.CLE_ID
   AND    IT.OBJECT1_ID1 = SI.ID1
   AND    IT.OBJECT1_ID2 = SI.ID2
   AND    IT.JTOT_OBJECT1_CODE = 'OKX_COVSITE'
   AND    KL.ID = p_line_id
   AND    SI.org_id = p_org_id;

Line: 1051

   Select fd.meaning
   from   okc_k_lines_b kl,
          okc_rule_groups_b rg,
          okc_rules_b rl,
          fnd_lookups fd
   where  kl.id = rg.cle_id
   and    kl.lse_id in(2,15,20)
   and    rg.id = rl.rgp_id
   and    rl.rule_information1 = fd.lookup_code
   and    rl.rule_information_category = 'CVE'
   and    fd.lookup_type = 'OKSCVETYPE'
   and    kl.id = p_line_id;

Line: 1066

   Select covtyp.meaning
   from   oks_k_lines_b okscle,
          oks_cov_types_v covtyp
   where  okscle.coverage_type = covtyp.code
   and    okscle.cle_id = p_line_id;

Line: 1087

   SELECT MEANING
   FROM   FND_LOOKUPS
   WHERE  LOOKUP_TYPE='OKS_BILLING_RATE'
   AND    LOOKUP_CODE = p_rate_code;