PA Class Categories and Codes

Description
Categories: BI Publisher, Financials
Application: Projects
Source: IMP: Class Categories and Codes (XML)
Short Name: PAXRWPCC_XML
DB package: PA_PAXRWPCC_XMLP_PKG
SELECT 	c.class_category class_category_1
,	c.description
,	m.meaning mandatory_flag
,	aa.meaning aa_flag
,	o.meaning pick_one_code_only_flag
,	c.start_date_active
,	c.end_date_active
FROM	pa_class_categories c
,	fnd_lookups m
,	fnd_lookups aa
,	fnd_lookups o
WHERE	c.class_category = nvl(:p_class_category, c.class_category)
and	c.mandatory_flag = m.lookup_code(+)
and	m.lookup_type(+) = 'YES_NO'
and	c.autoaccounting_flag = aa.lookup_code(+)
and	aa.lookup_type(+) = 'YES_NO'
and	c.pick_one_code_only_flag = o.lookup_code(+)
and	o.lookup_type(+) = 'YES_NO'
ORDER BY
	c.class_category,c.start_date_active
Parameter NameSQL textValidation
Class Category
 
LOV Oracle