DBA Data[Home] [Help]

APPS.QP_ATTR_MAPPING_PUB dependencies on OE_DEF_CONDITIONS

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 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 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'