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_ITEMS

Line 837: cz_config_items czi

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
841: AND czi.config_item_id = oe_line.configuration_id

Line 857: cz_config_items czi

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
861: AND czi.config_item_id = oe_line.configuration_id

Line 895: cz_config_items czi

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
899: AND czi.config_item_id = oe_line.configuration_id

Line 910: cz_config_items czi

906: BEGIN
907: SELECT czi.config_delta
908: INTO l_baseline_rev_nbr
909: FROM oe_order_lines oe_line,
910: cz_config_items czi
911: WHERE oe_line.line_id = p_line_id
912: AND czi.config_hdr_id = oe_line.config_header_id
913: AND czi.config_rev_nbr = oe_line.config_rev_nbr
914: AND czi.config_item_id = oe_line.configuration_id

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 984: FROM cz_config_items czi

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
988: AND nvl(czi.config_delta, 0) > 0;