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_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_MC_PATH_POSITION_NODES

Line 586: FROM ahl_mc_path_position_nodes mcpp,

582: -- Cursor to Know if position is controlled(container) position
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

Line 593: AND mcpp.position_key IN (select position_key from ahl_mc_path_position_nodes where path_position_id = c_path_position_id)

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)
593: AND mcpp.position_key IN (select position_key from ahl_mc_path_position_nodes where path_position_id = c_path_position_id)
594: AND mcrs.subject_id = mcpp.path_position_id
595: AND mcrs.subject_type = 'POSITION'
596: AND mcrs.operator IN ('MUST_HAVE', 'HAVE')
597: AND mcrs.object_type = 'TOT_CHILD_QUANTITY'

Line 1778: FROM AHL_MC_PATH_POSITION_NODES MCPP,

1774: -- Cursor to find position quantity of parent control position
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

Line 1786: FROM AHL_MC_PATH_POSITION_NODES

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)
1785: AND MCPP.position_key IN (SELECT position_key
1786: FROM AHL_MC_PATH_POSITION_NODES
1787: WHERE path_position_id = c_control_path_position_id)
1788: AND MCRS.subject_id = MCPP.path_position_id
1789: AND MCRS.subject_type = 'POSITION'
1790: AND MCRS.operator IN ('MUST_HAVE', 'HAVE')