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.AHL_MC_RULE_ENGINE_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 46: FROM AHL_MC_RULES_B rules, AHL_UNIT_CONFIG_HEADERS uc

42: IS
43: --
44: CURSOR get_rules_for_unit_csr(p_uc_header_id IN NUMBER, p_rtype IN VARCHAR2) IS
45: SELECT DISTINCT rules.rule_id, uc.csi_item_instance_id
46: FROM AHL_MC_RULES_B rules, AHL_UNIT_CONFIG_HEADERS uc
47: WHERE rules.mc_header_id = uc.master_config_id
48: AND uc.unit_config_header_id = p_uc_header_id
49: AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
50: AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 57: FROM AHL_UNIT_CONFIG_HEADERS uc

53: AND TRUNC(nvl(rules.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);
54: --
55: CURSOR get_all_subunits_csr(p_uc_header_id IN NUMBER) IS
56: SELECT uc.unit_config_header_id
57: FROM AHL_UNIT_CONFIG_HEADERS uc
58: START WITH uc.unit_config_header_id = p_uc_header_id
59: AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
60: AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
61: CONNECT BY PRIOR uc.unit_config_header_id = uc.PARENT_UC_HEADER_ID

Line 215: FROM AHL_MC_RULES_B rules, AHL_UNIT_CONFIG_HEADERS uc

211: IS
212: --
213: CURSOR get_rules_for_unit_csr(p_uc_header_id IN NUMBER, p_rtype IN VARCHAR2) IS
214: SELECT DISTINCT rules.rule_id, rules.rule_name, uc.csi_item_instance_id, uc.name
215: FROM AHL_MC_RULES_B rules, AHL_UNIT_CONFIG_HEADERS uc
216: WHERE rules.mc_header_id = uc.master_config_id
217: AND uc.unit_config_header_id = p_uc_header_id
218: AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
219: AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)

Line 226: FROM AHL_UNIT_CONFIG_HEADERS uc

222: AND TRUNC(nvl(rules.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);
223: --
224: CURSOR get_all_subunits_csr(p_uc_header_id IN NUMBER) IS
225: SELECT uc.unit_config_header_id
226: FROM AHL_UNIT_CONFIG_HEADERS uc
227: START WITH uc.unit_config_header_id = p_uc_header_id
228: AND TRUNC(nvl(uc.ACTIVE_START_DATE, sysdate-1)) < TRUNC(sysdate)
229: AND TRUNC(nvl(uc.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate)
230: CONNECT BY PRIOR uc.unit_config_header_id = uc.PARENT_UC_HEADER_ID

Line 239: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%TYPE;

235: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Rules_For_Unit';
236: l_csi_ii_id NUMBER;
237: l_rule_id NUMBER;
238: l_rule_name AHL_MC_RULES_B.RULE_NAME%TYPE;
239: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%TYPE;
240: l_eval_result VARCHAR2(1);
241: l_all_true_flag BOOLEAN;
242: l_uc_header_id NUMBER;
243: --

Line 453: FROM ahl_unit_config_headers uch

449: --instance is either top node or a subnode, matching mc_header_id
450: CURSOR get_uc_header_csr (p_csi_instance_id IN NUMBER,
451: p_mc_header_id IN NUMBER) IS
452: SELECT uch.csi_item_instance_id
453: FROM ahl_unit_config_headers uch
454: WHERE uch.master_config_id = p_mc_header_id
455: AND uch.csi_item_instance_id = p_csi_instance_id
456: UNION ALL
457: SELECT csi_ii.object_id

Line 461: FROM ahl_unit_config_headers

457: SELECT csi_ii.object_id
458: FROM csi_ii_relationships csi_ii
459: WHERE csi_ii.object_id IN
460: (SELECT csi_item_instance_id
461: FROM ahl_unit_config_headers
462: --mpothuku added '='
463: WHERE trunc(nvl(active_start_date,sysdate-1)) <= trunc(sysdate)
464: --mpothuku End
465: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))

Line 483: FROM ahl_unit_config_headers uch

479: AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate);
480: --
481: CURSOR get_uc_header_det_csr(p_csi_instance_id IN NUMBER) IS
482: SELECT uch.name
483: FROM ahl_unit_config_headers uch
484: WHERE uch.csi_item_instance_id = p_csi_instance_id;
485:
486: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007
487: -- Cursor to fetch the parent instance id for a given instance id.

Line 500: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%TYPE;

496: l_api_version CONSTANT NUMBER := 1.0;
497: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Rules_For_Position';
498: l_rule_id NUMBER;
499: l_rule_name AHL_MC_RULES_B.RULE_NAME%TYPE;
500: l_uc_name AHL_UNIT_CONFIG_HEADERS.NAME%TYPE;
501: l_mc_header_id NUMBER;
502: l_csi_ii_id NUMBER;
503: l_eval_result VARCHAR2(1);
504: l_all_true_flag BOOLEAN;

Line 835: FROM AHL_MC_HEADERS_B hd, AHL_UNIT_CONFIG_HEADERS uc

831: WHERE instance_id = p_csi_ii_id;
832: --
833: CURSOR get_mc_ids_csr (p_csi_ii_id IN NUMBER) IS
834: SELECT hd.mc_id, hd.version_number
835: FROM AHL_MC_HEADERS_B hd, AHL_UNIT_CONFIG_HEADERS uc
836: WHERE hd.mc_header_id = uc.master_config_id
837: AND uc.csi_item_instance_id = p_csi_ii_id;
838: --
839: CURSOR check_same_inventory_item_csr (p_csi_ii_id1 IN NUMBER,

Line 850: FROM AHL_UNIT_CONFIG_HEADERS uc1, AHL_UNIT_CONFIG_HEADERS uc2

846: --
847: CURSOR check_same_mc_header_csr (p_csi_ii_id1 IN NUMBER,
848: p_csi_ii_id2 IN NUMBER) IS
849: SELECT uc1.master_config_id
850: FROM AHL_UNIT_CONFIG_HEADERS uc1, AHL_UNIT_CONFIG_HEADERS uc2
851: WHERE uc1.csi_item_instance_id = p_csi_ii_id1
852: AND uc2.csi_item_instance_id = p_csi_ii_id2
853: AND uc1.master_config_id = uc2.master_config_id;
854: