APPS.QP_ATTR_MAPPING_PUB dependencies on OE_DEF_ATTR_CONDNS

Line 611: oe_def_attr_condns aconds,

607: arules.src_constant_value,
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)

Line 3286: oe_def_attr_condns c, oe_def_attr_def_rules d, qp_price_req_sources e

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'
3290: AND b.value_string = e.source_system_code

Line 3463: oe_def_attr_condns c, oe_def_attr_def_rules d, qp_price_req_sources e

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'
3467: AND b.value_string = e.source_system_code

Line 3644: oe_def_attr_condns d

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'
3648: AND b.value_string = c.source_system_code