Search from 700 + Posts

Jan 27, 2011

Query to connect cz_config_details_v cz AND oe_order_lines_all tables

SELECT cz.*
         FROM   cz_config_details_v cz, oe_order_lines_all oe
         WHERE  oe.line_id = p_model_line_id
         AND    oe.config_header_id = cz.config_hdr_id
         AND    oe.config_rev_nbr   = cz.config_rev_nbr
         AND    oe.component_code   = cz.component_code;

No comments:

Post a Comment