eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CONFIG_TSO_PVT dependencies on CZ_CONFIG_HDRS

Line 836: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

832: END IF;
833:
834: SELECT cz_hdr.baseline_rev_nbr
835: INTO l_baseline_rev_nbr
836: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
837: cz_config_items czi
838: WHERE oe_line.top_model_line_id = p_top_model_line_id
839: AND czi.config_hdr_id = oe_line.config_header_id
840: AND czi.config_rev_nbr = oe_line.config_rev_nbr

Line 856: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

852:
853: BEGIN
854: SELECT czi.config_delta
855: INTO l_baseline_rev_nbr
856: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
857: cz_config_items czi
858: WHERE oe_line.top_model_line_id = p_top_model_line_id
859: AND czi.config_hdr_id = oe_line.config_header_id
860: AND czi.config_rev_nbr = oe_line.config_rev_nbr

Line 894: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

890: END IF;
891:
892: SELECT cz_hdr.baseline_rev_nbr
893: INTO l_baseline_rev_nbr
894: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
895: cz_config_items czi
896: WHERE oe_line.line_id = p_line_id
897: AND czi.config_hdr_id = oe_line.config_header_id
898: AND czi.config_rev_nbr = oe_line.config_rev_nbr

Line 965: FROM cz_config_hdrs cz_hdr, cz_config_items czi

961:
962:
963: SELECT cz_hdr.baseline_rev_nbr
964: INTO l_baseline_rev_nbr
965: FROM cz_config_hdrs cz_hdr, cz_config_items czi
966: WHERE czi.config_hdr_id = p_line_rec.config_header_id
967: AND czi.config_rev_nbr = p_line_rec.config_rev_nbr
968: AND czi.config_item_id = p_line_rec.configuration_id
969: AND cz_hdr.config_hdr_id = czi.instance_hdr_id

Line 983: --FROM cz_config_hdrs cz_hdr, cz_config_items czi

979: BEGIN
980: SELECT czi.config_delta
981: INTO l_baseline_rev_nbr
982: --bug3667985 fix
983: --FROM cz_config_hdrs cz_hdr, cz_config_items czi
984: FROM cz_config_items czi
985: WHERE czi.config_hdr_id = p_line_rec.config_header_id
986: AND czi.config_rev_nbr = p_line_rec.config_rev_nbr
987: AND czi.config_item_id = p_line_rec.configuration_id

Line 3375: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

3371: Begin
3372:
3373: SELECT cz_hdr.baseline_rev_nbr
3374: INTO l_baseline_rev_nbr
3375: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
3376: cz_config_details_v czv
3377: WHERE oe_line.top_model_line_id = p_top_model_line_id
3378: AND oe_line.configuration_id = P_instance_item_id
3379: AND czv.config_hdr_id = oe_line.config_header_id

Line 3479: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,

3475:
3476: Begin
3477: SELECT cz_hdr.baseline_rev_nbr
3478: INTO l_baseline_rev_nbr
3479: FROM cz_config_hdrs cz_hdr, oe_order_lines oe_line,
3480: cz_config_details_v czv
3481: WHERE oe_line.line_id = p_line_id
3482: AND czv.config_hdr_id = oe_line.config_header_id
3483: AND czv.config_rev_nbr = oe_line.config_rev_nbr