DBA Data[Home] [Help]

APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_MC_HEADERS_B

Line 588: ahl_mc_headers_b mch,

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
592: AND mch.version_number = NVL(mcpp.version_number, mch.version_number)

Line 1780: AHL_MC_HEADERS_B MCH,

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
1784: AND MCH.version_number = NVL(MCPP.version_number, MCH.version_number)