eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_TERMS_AND_CONDS_PVT SQL Statements

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

Line: 27


SELECT
1 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
--'LASEBB|LASERE|LASEAD|LASEAM|LASEIN|LASEEX' RULE_GROUP,
--'LASEBB-LASEFM|LASERE-LASEPR|LASEAD-LASEPR|LASEAM-LASEPR|LASEIN-LASEPR|LASEEX-LASEPR' RULE_SEQUENCE,
'LASEBB' RULE_GROUP,
'LASEBB-LASEFM' RULE_SEQUENCE,
'GROUP' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_LA_SEC_TC' REGION,
'NO' CURRENCY ,
'NO' DISABLED ,
'OKLLASECLASEPR' TOKEN ,
'oklLaSecRules.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_LA_SEC_LINKS' AND LOOKUP_CODE = 'OKLLASECLASEPR'
UNION
SELECT 2 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'LASEIR' RULE_GROUP,
--'LASEIR-LASEIR|LASEIR-LAIVAR|LASEIR-LAICLC|LASEIR-LAFORM' RULE_SEQUENCE,
'LASEIR-LASEIR' RULE_SEQUENCE,
'RULE' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_LA_SEC_TC' REGION,
'NO' CURRENCY,
'NO' DISABLED,
'OKLLASECLASEIR' TOKEN ,
'oklLaSecRules.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_LA_SEC_LINKS' AND LOOKUP_CODE = 'OKLLASECLASEIR'
UNION
SELECT 2 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'LASEAC' RULE_GROUP,
'LASEAC-LASEAC' RULE_SEQUENCE,
'RULE' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_LA_SEC_TC' REGION,
'NO' CURRENCY,
'NO' DISABLED,
'OKLLASECLASEAC' TOKEN ,
'oklLaSecRules.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_LA_SEC_LINKS' AND LOOKUP_CODE = 'OKLLASECLASEAC'

ORDER BY 1;

Line: 176


SELECT
1 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'LABILL' RULE_GROUP,
'LABILL-BTO|LABILL-LAPMTH|LABILL-LABACC|LABILL-LAINVD|LABILL-LAINPR' RULE_SEQUENCE,
'SINGLE' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'NO' CURRENCY ,
'NO' DISABLED ,
'OKLLABILLINGSETUPLABILL' TOKEN ,
'oklLaBillingSetup.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLABILLINGSETUPLABILL'
UNION
SELECT
2 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'LALCGR|LALIGR' RULE_GROUP,
Null RULE_SEQUENCE,
'GROUP' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'NO' CURRENCY , 'NO' DISABLED ,
'OKLLARULEGROUPSLALCGR' TOKEN ,
'oklLaRuleGroups.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULEGROUPSLALCGR'
UNION
SELECT 3 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'LARNOP' RULE_GROUP,
NULL RULE_SEQUENCE,
'GROUP' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'YES' CURRENCY,
'NO' DISABLED,
'OKLLARULEGROUPSLARNOP' TOKEN ,
'oklLaRuleGroups.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULEGROUPSLARNOP'
UNION
SELECT 4 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'LAIIND' RULE_GROUP,
'LAIIND-LAINTP|LAIIND-LAICON|LAIIND-LAIVAR|LAIIND-LAICLC|LAIIND-LAFORM' RULE_SEQUENCE,
'RULE' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'NO' CURRENCY,
'NO' DISABLED,
'OKLLARULESLAIIND' TOKEN ,
'oklLaRules.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESLAIIND'
UNION
SELECT
5 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'LASDEP|LAFCTG|LAEVEL' RULE_GROUP,
NULL RULE_SEQUENCE,
'GROUP' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'NO' CURRENCY,
'NO' DISABLED,
'OKLLARULESLASDEP' TOKEN ,
'oklLaRuleGroups.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESLASDEP'
UNION
SELECT
6 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'LARVIN' RULE_GROUP,
'LARVIN-LARVAU|LARVIN-LARVAM' RULE_SEQUENCE,
'GROUP' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'NO' CURRENCY,
'NO' DISABLED,
'OKLLARULESLARVIN' TOKEN ,
'oklLaRules.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESLARVIN'
UNION
SELECT
7 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'LAFLLG' RULE_GROUP,
'LAAFLG-LAFLLN|LAAFLG-LAFLTL' RULE_SEQUENCE,
'RULE' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'NO' CURRENCY,
'NO' DISABLED,
'OKLLARULESLAFLLG' TOKEN ,
'oklLaRules.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESLAFLLG'
UNION
SELECT
8 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'AMLARL|AMREPQ' RULE_GROUP,
'DEFAULT' RULE_SEQUENCE,
'GROUP' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'YES' CURRENCY,
'NO' DISABLED,
'OKLLARULESAMLARL' TOKEN ,
'oklLaRules.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMLARL'
UNION
SELECT
9 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'AMTEOC|AMTFOC' RULE_GROUP,
'DEFAULT' RULE_SEQUENCE,
'GROUP' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'YES' CURRENCY,
'NO' DISABLED,
'OKLLARULESAMTEOC' TOKEN ,
'oklLaRules.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMTEOC'
UNION
SELECT
10 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'AMTQPR|AMTPAR|AMTGAL|AMQR1R|AMQR5A|AMQR9F' RULE_GROUP,
'DEFAULT' RULE_SEQUENCE,
'GROUP' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'YES' CURRENCY,
'NO' DISABLED,
'OKLLARULESAMTQPR' TOKEN ,
'oklLaRules.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMTQPR'
UNION
SELECT
11 SEQ_NO,
FND.MEANING GROUP_TITLE,
FND.DESCRIPTION DESCRIPTION,
'AMTEWC' RULE_GROUP,
'DEFAULT' RULE_SEQUENCE,
'GROUP-RULE' TITLE_STYLE,
'OKL_TERMS_CONDS' PAGETITLE,
'OKL_TC_ATTRIBUTES' REGION,
'YES' CURRENCY,
'NO' DISABLED,
'OKLLARULESAMTEWC' TOKEN ,
'oklLaRules.jsp' JSP
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMTEWC'
UNION
SELECT
12 SEQ_NO,
 FND.MEANING GROUP_TITLE,
 FND.DESCRIPTION DESCRIPTION,
 'AMTFWC' RULE_GROUP,
 'DEFAULT' RULE_SEQUENCE,
 'GROUP-RULE' TITLE_STYLE,
 'OKL_TERMS_CONDS' PAGETITLE,
 'OKL_TC_ATTRIBUTES' REGION,
 'YES' CURRENCY,
 'NO' DISABLED,
 'OKLLARULESAMTFWC' TOKEN ,
 'oklLaRules.jsp' JSP
 FROM FND_LOOKUPS FND
 WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMTFWC'
 UNION
 SELECT
 13 SEQ_NO,
 FND.MEANING GROUP_TITLE,
  FND.DESCRIPTION DESCRIPTION,
  'AMCOPO' RULE_GROUP,
  'DEFAULT' RULE_SEQUENCE,
  'GROUP' TITLE_STYLE, 'OKL_TERMS_CONDS'
  PAGETITLE, 'OKL_TC_ATTRIBUTES' REGION,
  'YES' CURRENCY,
  'NO' DISABLED,
  'OKLLARULESAMCOPO' TOKEN ,
  'oklLaRules.jsp' JSP
  FROM FND_LOOKUPS FND
  WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMCOPO'
  UNION
  SELECT
  14 SEQ_NO,
  FND.MEANING GROUP_TITLE,
  FND.DESCRIPTION DESCRIPTION,
  'SUMMARY' RULE_GROUP,
  'DEFAULT' RULE_SEQUENCE,
  'NO' TITLE_STYLE,
  'NO' PAGETITLE,
  'NO' REGION,
  'NO' CURRENCY,
  'NO' DISABLED,
  'VENDOR-PROGRAMS' TOKEN ,
  'oklLaRules.jsp' JSP
  FROM FND_LOOKUPS FND
  WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'VENDOR-PROGRAMS'
  UNION
  SELECT
  15 SEQ_NO,
  FND.MEANING GROUP_TITLE,
  FND.DESCRIPTION DESCRIPTION,
  'LAHDTX' RULE_GROUP,
  'LAHDTX-LAPRTX|LAHDTX-LAMETX|LAHDTX-LAAUTX' RULE_SEQUENCE,
  'RULE' TITLE_STYLE,
  'OKL_TERMS_CONDS' PAGETITLE,
  'OKL_TC_ATTRIBUTES' REGION,
  'NO' CURRENCY,
  'NO' DISABLED,
  'OKLLARULESLAHDTX' TOKEN ,
  'oklLaRules.jsp' JSP
  FROM FND_LOOKUPS FND
  WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESLAHDTX' ORDER BY 1;