APPS.QP_ATTR_MAPPING_PUB dependencies on OE_DEF_CONDN_ELEMS

Line 679: oe_def_condn_elems condelem,

675: condelem.value_string,
676: condelem.attribute_code
677: FROM
678: oe_def_attr_condns aconds,
679: oe_def_condn_elems condelem,
680: oe_def_attr_def_rules arules
681: WHERE
682: aconds.database_object_name IN (p_db1, p_db2)
683: AND condelem.condition_id = aconds.condition_id

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

685: AND arules.attr_def_condition_id = aconds.attr_def_condition_id
686: --added this condition to look at enabled_flag to avoid duplicate sourcing due to
687: --OM changes to lct. enabled_flag is a new column introduced--spgopal
688: AND NVL(aconds.enabled_flag, 'Y') = 'Y'
689: AND EXISTS (SELECT 'x' FROM qp_price_req_sources prs,oe_def_condn_elems condelem1
690: WHERE condelem1.attribute_code = 'SRC_SYSTEM_CODE'
691: AND condelem1.value_string = prs.source_system_code
692: AND prs.request_type_code = p_request_type_code
693: AND condelem.condition_id = condelem1.condition_id);

Line 3543: FROM oe_def_conditions a, oe_def_condn_elems b,

3539: AND pricing_attribute IS NOT NULL;
3540:
3541: CURSOR l_cond_cursor(p_pricing_attr VARCHAR2) IS
3542: SELECT c.condition_id, d.attr_def_condition_id
3543: FROM oe_def_conditions a, oe_def_condn_elems b,
3544: oe_def_attr_condns c, oe_def_attr_def_rules d, qp_price_req_sources e
3545: WHERE a.database_object_name LIKE 'QP%'
3546: AND a.condition_id = b.condition_id
3547: AND b.attribute_code = 'SRC_SYSTEM_CODE'

Line 3597: FROM oe_def_condn_elems

3593: EXIT WHEN l_cond_cursor%NOTFOUND;
3594:
3595: SELECT value_string
3596: INTO l_context_name
3597: FROM oe_def_condn_elems
3598: WHERE condition_id = l_condition_id
3599: AND attribute_code = 'PRICING_CONTEXT';
3600:
3601: IF l_debug = Fnd_Api.G_TRUE THEN

Line 3720: FROM oe_def_conditions a, oe_def_condn_elems b,

3716: AND pricing_attribute IS NOT NULL;
3717:
3718: CURSOR l_cond_cursor(p_pricing_attr VARCHAR2) IS
3719: SELECT c.condition_id, d.attr_def_condition_id
3720: FROM oe_def_conditions a, oe_def_condn_elems b,
3721: oe_def_attr_condns c, oe_def_attr_def_rules d, qp_price_req_sources e
3722: WHERE a.database_object_name LIKE 'QP%'
3723: AND a.condition_id = b.condition_id
3724: AND b.attribute_code = 'SRC_SYSTEM_CODE'

Line 3774: FROM oe_def_condn_elems

3770: EXIT WHEN l_cond_cursor%NOTFOUND;
3771:
3772: SELECT value_string
3773: INTO l_context_name
3774: FROM oe_def_condn_elems
3775: WHERE condition_id = l_condition_id
3776: AND attribute_code = 'PRICING_CONTEXT';
3777:
3778: IF l_debug = Fnd_Api.G_TRUE THEN

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

3897:
3898:
3899: CURSOR l_sourced_contexts IS
3900: SELECT DISTINCT b.condition_id
3901: FROM oe_def_conditions a, oe_def_condn_elems b, qp_price_req_sources c,
3902: oe_def_attr_condns d
3903: WHERE a.database_object_name LIKE 'QP%'
3904: AND a.condition_id = b.condition_id
3905: AND b.attribute_code = 'SRC_SYSTEM_CODE'

Line 3951: FROM oe_def_condn_elems

3947: EXIT WHEN l_sourced_contexts%NOTFOUND;
3948:
3949: SELECT value_string
3950: INTO l_context_name
3951: FROM oe_def_condn_elems
3952: WHERE condition_id = l_condition_id
3953: AND attribute_code = 'PRICING_CONTEXT';
3954:
3955: IF l_debug = Fnd_Api.G_TRUE THEN