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_PVT dependencies on DUAL

Line 202: FROM DUAL;

198: WHERE INVENTORY_ITEM_ID = p_inv_item_id;
199: --
200: CURSOR get_position_ref_meaning_csr(p_position_id IN NUMBER) IS
201: SELECT AHL_MC_PATH_POSITION_PVT.get_posref_by_id(p_position_id)
202: FROM DUAL;
203: --
204: CURSOR get_mc_name_csr (p_mc_id IN NUMBER) IS
205: SELECT distinct name
206: FROM ahl_mc_headers_b

Line 466: SELECT ahl_mc_rule_statements_s.nextval FROM DUAL;

462: x_rule_stmt_id OUT NOCOPY NUMBER)
463: IS
464: --
465: CURSOR next_rule_stmt_id_csr IS
466: SELECT ahl_mc_rule_statements_s.nextval FROM DUAL;
467:
468: --
469: l_stmt_rec AHL_MC_RULE_PVT.Rule_Stmt_Rec_Type;
470: l_ui_stmt_rec AHL_MC_RULE_PVT.UI_Rule_Stmt_Rec_Type;

Line 867: FROM dual;

863: END IF;
864:
865: SELECT AHL_MC_RULES_B_S.nextval
866: INTO p_x_rule_rec.rule_id
867: FROM dual;
868:
869: --Convert the flat structure into a rule tree.
870: Build_rule_tree( p_rule_id => p_x_rule_rec.rule_id,
871: p_rule_stmt_tbl=> p_rule_stmt_tbl,

Line 1603: FROM dual;

1599: SAVEPOINT copy_rule_pvt;
1600:
1601: SELECT AHL_MC_RULES_B_S.nextval
1602: INTO l_new_rule_id
1603: FROM dual;
1604:
1605: --Copy the Rule Record
1606: AHL_MC_RULES_PKG.INSERT_ROW (
1607: X_ROWID => l_row_id,