VIEW: APPS.OKL_TERMS_AND_COND_UV

Source

View Text - Preformatted

SELECT 1 SEQ_NO, FND.MEANING GROUP_TITLE, FND.DESCRIPTION DESCRIPTION, 'LABILL' RULE_GROUP, '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 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 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 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, 'LASDEP|LAFCTG|LAEVEL|LAPREF' RULE_GROUP, 'LASDEP-LASDEP|LAFCTG-LAFCTG|LAEVEL-LAEVEL|LAEVEL-LAEVPT|LAPREF-LAIVAR' RULE_SEQUENCE, 'GROUP' TITLE_STYLE, 'OKL_TERMS_CONDS' PAGETITLE, 'OKL_TC_ATTRIBUTES' REGION, 'NO' CURRENCY, 'NO' DISABLED, 'OKLLARULESLASDEP' TOKEN FROM FND_LOOKUPS FND WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESLASDEP' UNION SELECT 5 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 FROM FND_LOOKUPS FND WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESLARVIN' UNION SELECT 6 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 FROM FND_LOOKUPS FND WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESLAFLLG' UNION SELECT 7 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 FROM FND_LOOKUPS FND WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMLARL' UNION SELECT 8 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 FROM FND_LOOKUPS FND WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMTEOC' UNION SELECT 9 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 FROM FND_LOOKUPS FND WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMTQPR' UNION SELECT 10 SEQ_NO, FND.MEANING GROUP_TITLE, FND.DESCRIPTION DESCRIPTION, 'AMTEWC' RULE_GROUP, 'AMTEWC-AMATQC|AMTEWC-AMBCOC|AMTEWC-AMCQDR|AMTEWC-AMCQFE|AMTEWC-AMCRFE|AMTEWC-AMCRIN|AMTEWC-AMCSDD|AMTEWC-AMCTPE|AMTEWC-AMAFEE|AMTEWC-AMEFEE|AMTEWC-AMFFEE|AMTEWC-AMGFEE|AMTEWC-AMIFEE|AMTEWC-AMMFEE|AMTEWC-AMPFEE|AMTEWC-AMRFEE|AMTEWC-AMPRTX|AMTEWC-AMYFEE|AMTEWC-AMYOUB|AMTEWC-AMYSAM' RULE_SEQUENCE, 'GROUP-RULE' TITLE_STYLE, 'OKL_TERMS_CONDS' PAGETITLE, 'OKL_TC_ATTRIBUTES' REGION, 'YES' CURRENCY, 'NO' DISABLED, 'OKLLARULESAMTEWC' TOKEN FROM FND_LOOKUPS FND WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMTEWC' UNION SELECT 11 SEQ_NO, FND.MEANING GROUP_TITLE, FND.DESCRIPTION DESCRIPTION, 'AMTFWC' RULE_GROUP, 'AMTFWC-AMATQC|AMTFWC-AMBCOC|AMTFWC-AMCQDR|AMTFWC-AMCQFE|AMTFWC-AMCRFE|AMTFWC-AMCRIN|AMTFWC-AMCSDD|AMTFWC-AMCTPE|AMTFWC-AMAFEE|AMTFWC-AMEFEE|AMTFWC-AMFFEE|AMTFWC-AMGFEE|AMTFWC-AMIFEE|AMTFWC-AMMFEE|AMTFWC-AMPFEE|AMTFWC-AMRFEE|AMTFWC-AMPRTX|AMTFWC-AMYFEE|AMTFWC-AMYOUB|AMTFWC-AMYSAM' RULE_SEQUENCE, 'GROUP-RULE' TITLE_STYLE, 'OKL_TERMS_CONDS' PAGETITLE, 'OKL_TC_ATTRIBUTES' REGION, 'YES' CURRENCY, 'NO' DISABLED, 'OKLLARULESAMTFWC' TOKEN FROM FND_LOOKUPS FND WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESAMTFWC' UNION SELECT 12 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 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, 'LAHDTX' RULE_GROUP, 'LAHDTX-LAPRTX|LAHDTX-LASTCL|LAHDTX-LASTPR|LAHDTX-LAMETX|LAHDTX-LAAUTX' RULE_SEQUENCE, 'RULE' TITLE_STYLE, 'OKL_TERMS_CONDS' PAGETITLE, 'OKL_TC_ATTRIBUTES' REGION, 'NO' CURRENCY, 'NO' DISABLED, 'OKLLARULESLAHDTX' TOKEN FROM FND_LOOKUPS FND WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'OKLLARULESLAHDTX' UNION SELECT 15 SEQ_NO, FND.MEANING GROUP_TITLE, FND.DESCRIPTION DESCRIPTION, 'EVGPSTH' RULE_GROUP, 'EVGPSTH' RULE_SEQUENCE, 'NO' TITLE_STYLE, 'NO' PAGETITLE, 'NO' REGION, 'NO' CURRENCY, 'NO' DISABLED, 'EVGPSTH' TOKEN FROM FND_LOOKUPS FND WHERE LOOKUP_TYPE = 'OKL_TC_LINKS' AND LOOKUP_CODE = 'EVGPSTH' ORDER BY 1

View Text - HTML Formatted

SELECT 1 SEQ_NO
, FND.MEANING GROUP_TITLE
, FND.DESCRIPTION DESCRIPTION
, 'LABILL' RULE_GROUP
, '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
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
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
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
, 'LASDEP|LAFCTG|LAEVEL|LAPREF' RULE_GROUP
, 'LASDEP-LASDEP|LAFCTG-LAFCTG|LAEVEL-LAEVEL|LAEVEL-LAEVPT|LAPREF-LAIVAR' RULE_SEQUENCE
, 'GROUP' TITLE_STYLE
, 'OKL_TERMS_CONDS' PAGETITLE
, 'OKL_TC_ATTRIBUTES' REGION
, 'NO' CURRENCY
, 'NO' DISABLED
, 'OKLLARULESLASDEP' TOKEN
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS'
AND LOOKUP_CODE = 'OKLLARULESLASDEP' UNION SELECT 5 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
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS'
AND LOOKUP_CODE = 'OKLLARULESLARVIN' UNION SELECT 6 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
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS'
AND LOOKUP_CODE = 'OKLLARULESLAFLLG' UNION SELECT 7 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
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS'
AND LOOKUP_CODE = 'OKLLARULESAMLARL' UNION SELECT 8 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
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS'
AND LOOKUP_CODE = 'OKLLARULESAMTEOC' UNION SELECT 9 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
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS'
AND LOOKUP_CODE = 'OKLLARULESAMTQPR' UNION SELECT 10 SEQ_NO
, FND.MEANING GROUP_TITLE
, FND.DESCRIPTION DESCRIPTION
, 'AMTEWC' RULE_GROUP
, 'AMTEWC-AMATQC|AMTEWC-AMBCOC|AMTEWC-AMCQDR|AMTEWC-AMCQFE|AMTEWC-AMCRFE|AMTEWC-AMCRIN|AMTEWC-AMCSDD|AMTEWC-AMCTPE|AMTEWC-AMAFEE|AMTEWC-AMEFEE|AMTEWC-AMFFEE|AMTEWC-AMGFEE|AMTEWC-AMIFEE|AMTEWC-AMMFEE|AMTEWC-AMPFEE|AMTEWC-AMRFEE|AMTEWC-AMPRTX|AMTEWC-AMYFEE|AMTEWC-AMYOUB|AMTEWC-AMYSAM' RULE_SEQUENCE
, 'GROUP-RULE' TITLE_STYLE
, 'OKL_TERMS_CONDS' PAGETITLE
, 'OKL_TC_ATTRIBUTES' REGION
, 'YES' CURRENCY
, 'NO' DISABLED
, 'OKLLARULESAMTEWC' TOKEN
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS'
AND LOOKUP_CODE = 'OKLLARULESAMTEWC' UNION SELECT 11 SEQ_NO
, FND.MEANING GROUP_TITLE
, FND.DESCRIPTION DESCRIPTION
, 'AMTFWC' RULE_GROUP
, 'AMTFWC-AMATQC|AMTFWC-AMBCOC|AMTFWC-AMCQDR|AMTFWC-AMCQFE|AMTFWC-AMCRFE|AMTFWC-AMCRIN|AMTFWC-AMCSDD|AMTFWC-AMCTPE|AMTFWC-AMAFEE|AMTFWC-AMEFEE|AMTFWC-AMFFEE|AMTFWC-AMGFEE|AMTFWC-AMIFEE|AMTFWC-AMMFEE|AMTFWC-AMPFEE|AMTFWC-AMRFEE|AMTFWC-AMPRTX|AMTFWC-AMYFEE|AMTFWC-AMYOUB|AMTFWC-AMYSAM' RULE_SEQUENCE
, 'GROUP-RULE' TITLE_STYLE
, 'OKL_TERMS_CONDS' PAGETITLE
, 'OKL_TC_ATTRIBUTES' REGION
, 'YES' CURRENCY
, 'NO' DISABLED
, 'OKLLARULESAMTFWC' TOKEN
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS'
AND LOOKUP_CODE = 'OKLLARULESAMTFWC' UNION SELECT 12 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
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
, 'LAHDTX' RULE_GROUP
, 'LAHDTX-LAPRTX|LAHDTX-LASTCL|LAHDTX-LASTPR|LAHDTX-LAMETX|LAHDTX-LAAUTX' RULE_SEQUENCE
, 'RULE' TITLE_STYLE
, 'OKL_TERMS_CONDS' PAGETITLE
, 'OKL_TC_ATTRIBUTES' REGION
, 'NO' CURRENCY
, 'NO' DISABLED
, 'OKLLARULESLAHDTX' TOKEN
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS'
AND LOOKUP_CODE = 'OKLLARULESLAHDTX' UNION SELECT 15 SEQ_NO
, FND.MEANING GROUP_TITLE
, FND.DESCRIPTION DESCRIPTION
, 'EVGPSTH' RULE_GROUP
, 'EVGPSTH' RULE_SEQUENCE
, 'NO' TITLE_STYLE
, 'NO' PAGETITLE
, 'NO' REGION
, 'NO' CURRENCY
, 'NO' DISABLED
, 'EVGPSTH' TOKEN
FROM FND_LOOKUPS FND
WHERE LOOKUP_TYPE = 'OKL_TC_LINKS'
AND LOOKUP_CODE = 'EVGPSTH' ORDER BY 1