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_UMP_UF_PVT dependencies on AHL_PC_ASSOCIATIONS

Line 583: FROM ahl_pc_headers_b a, ahl_pc_nodes_b b, ahl_pc_associations c

579: l_exists VARCHAR2(1);
580:
581: CURSOR pc_status_check_up_csr(p_unit_item_id IN NUMBER,p_association_type IN VARCHAR2) IS
582: SELECT a.primary_flag,a.status
583: FROM ahl_pc_headers_b a, ahl_pc_nodes_b b, ahl_pc_associations c
584: WHERE a.pc_header_id = b.pc_header_id AND b.pc_node_id = c.pc_node_id AND
585: a.primary_flag = G_PC_PRIMARY_FLAG AND
586: a.status = G_COMPLETE_STATUS AND
587: c.association_type_flag = p_association_type AND

Line 1974: FROM ahl_pc_associations a, ahl_pc_nodes_b b, ahl_pc_headers_b c

1970: c_type IN VARCHAR2,
1971: c_primary_flag IN VARCHAR2,
1972: c_complete_status IN VARCHAR2 ) IS
1973: SELECT a.pc_node_id
1974: FROM ahl_pc_associations a, ahl_pc_nodes_b b, ahl_pc_headers_b c
1975: WHERE a.unit_item_id = c_unit_config_header_id
1976: AND a.association_type_flag = c_type
1977: AND a.pc_node_id = b.pc_node_id
1978: AND b.pc_header_id = c.pc_header_id