DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_MC_RULE_STATEMENTS

Line 587: ahl_mc_rule_statements mcrs,

583: CURSOR get_controled_position_csr(c_mc_header_id IN NUMBER,
584: c_path_position_id IN NUMBER) IS
585: SELECT 'Y', MCRS.object_attribute1
586: FROM ahl_mc_path_position_nodes mcpp,
587: ahl_mc_rule_statements mcrs,
588: ahl_mc_headers_b mch,
589: ahl_mc_rules_b mcr
590: WHERE mch.mc_header_id = c_mc_header_id
591: AND mcpp.mc_id = mch.mc_id

Line 1779: AHL_MC_RULE_STATEMENTS MCRS,

1775: CURSOR get_control_pos_qty_csr (c_mc_header_id NUMBER,
1776: c_control_path_position_id NUMBER) IS
1777: SELECT MCRS.object_attribute1
1778: FROM AHL_MC_PATH_POSITION_NODES MCPP,
1779: AHL_MC_RULE_STATEMENTS MCRS,
1780: AHL_MC_HEADERS_B MCH,
1781: AHL_MC_RULES_B MCR
1782: WHERE MCH.mc_header_id = c_mc_header_id
1783: AND MCPP.mc_id = MCH.mc_id