APPS.QP_ATTR_MAPPING_PUB dependencies on OE_DEF_CONDN_ELEMS

Line 612: oe_def_condn_elems condelem,

608: condelem.value_string,
609: condelem.attribute_code
610: FROM
611: oe_def_attr_condns aconds,
612: oe_def_condn_elems condelem,
613: oe_def_attr_def_rules arules
614: WHERE
615: aconds.database_object_name IN (p_db1, p_db2)
616: AND condelem.condition_id = aconds.condition_id

Line 622: AND EXISTS (SELECT 'x' FROM qp_price_req_sources prs,oe_def_condn_elems condelem1

618: AND arules.attr_def_condition_id = aconds.attr_def_condition_id
619: --added this condition to look at enabled_flag to avoid duplicate sourcing due to
620: --OM changes to lct. enabled_flag is a new column introduced--spgopal
621: AND NVL(aconds.enabled_flag, 'Y') = 'Y'
622: AND EXISTS (SELECT 'x' FROM qp_price_req_sources prs,oe_def_condn_elems condelem1
623: WHERE condelem1.attribute_code = 'SRC_SYSTEM_CODE'
624: AND condelem1.value_string = prs.source_system_code
625: AND prs.request_type_code = p_request_type_code
626: AND condelem.condition_id = condelem1.condition_id);

Line 3285: FROM oe_def_conditions a, oe_def_condn_elems b,

3281: AND pricing_attribute IS NOT NULL;
3282:
3283: CURSOR l_cond_cursor(p_pricing_attr VARCHAR2) IS
3284: SELECT c.condition_id, d.attr_def_condition_id
3285: FROM oe_def_conditions a, oe_def_condn_elems b,
3286: oe_def_attr_condns c, oe_def_attr_def_rules d, qp_price_req_sources e
3287: WHERE a.database_object_name LIKE 'QP%'
3288: AND a.condition_id = b.condition_id
3289: AND b.attribute_code = 'SRC_SYSTEM_CODE'

Line 3339: FROM oe_def_condn_elems

3335: EXIT WHEN l_cond_cursor%NOTFOUND;
3336:
3337: SELECT value_string
3338: INTO l_context_name
3339: FROM oe_def_condn_elems
3340: WHERE condition_id = l_condition_id
3341: AND attribute_code = 'PRICING_CONTEXT';
3342:
3343: IF l_debug = Fnd_Api.G_TRUE THEN

Line 3462: FROM oe_def_conditions a, oe_def_condn_elems b,

3458: AND pricing_attribute IS NOT NULL;
3459:
3460: CURSOR l_cond_cursor(p_pricing_attr VARCHAR2) IS
3461: SELECT c.condition_id, d.attr_def_condition_id
3462: FROM oe_def_conditions a, oe_def_condn_elems b,
3463: oe_def_attr_condns c, oe_def_attr_def_rules d, qp_price_req_sources e
3464: WHERE a.database_object_name LIKE 'QP%'
3465: AND a.condition_id = b.condition_id
3466: AND b.attribute_code = 'SRC_SYSTEM_CODE'

Line 3516: FROM oe_def_condn_elems

3512: EXIT WHEN l_cond_cursor%NOTFOUND;
3513:
3514: SELECT value_string
3515: INTO l_context_name
3516: FROM oe_def_condn_elems
3517: WHERE condition_id = l_condition_id
3518: AND attribute_code = 'PRICING_CONTEXT';
3519:
3520: IF l_debug = Fnd_Api.G_TRUE THEN

Line 3643: FROM oe_def_conditions a, oe_def_condn_elems b, qp_price_req_sources c,

3639:
3640:
3641: CURSOR l_sourced_contexts IS
3642: SELECT DISTINCT b.condition_id
3643: FROM oe_def_conditions a, oe_def_condn_elems b, qp_price_req_sources c,
3644: oe_def_attr_condns d
3645: WHERE a.database_object_name LIKE 'QP%'
3646: AND a.condition_id = b.condition_id
3647: AND b.attribute_code = 'SRC_SYSTEM_CODE'

Line 3693: FROM oe_def_condn_elems

3689: EXIT WHEN l_sourced_contexts%NOTFOUND;
3690:
3691: SELECT value_string
3692: INTO l_context_name
3693: FROM oe_def_condn_elems
3694: WHERE condition_id = l_condition_id
3695: AND attribute_code = 'PRICING_CONTEXT';
3696:
3697: IF l_debug = Fnd_Api.G_TRUE THEN