APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 5554: AHL_UNIT_CONFIG_HEADERS UCH

5550: AHL_MR_HEADERS_B MR,
5551: AHL_MR_EFFECTIVITIES EFF,
5552: AHL_MC_PATH_POSITION_NODES NODE,
5553: AHL_MC_HEADERS_B MC,
5554: AHL_UNIT_CONFIG_HEADERS UCH
5555: WHERE INTV.COUNTER_ID = CNTR.COUNTER_ID
5556: AND UOM.UOM_CODE = CNTR.UOM_CODE
5557: AND BG.VISIT_ID = AVB.VISIT_ID
5558: AND BG.UOM_CODE = CNTR.UOM_CODE

Line 6066: || ' (SELECT CSI_ITEM_INSTANCE_ID FROM AHL_UNIT_CONFIG_HEADERS'

6062: --Visit Unit filter
6063: IF(p_demand_Record.Visit_Unit IS NOT NULL) THEN
6064: IF(INSTR(p_demand_Record.Visit_Unit, '%', 1, 1) <> 0) THEN
6065: l_base_query := l_base_query || ' AND ITEM_INSTANCE_ID IN '
6066: || ' (SELECT CSI_ITEM_INSTANCE_ID FROM AHL_UNIT_CONFIG_HEADERS'
6067: || ' WHERE NAME LIKE ''' || p_demand_Record.Visit_Unit || ''')';
6068: ELSE
6069: l_base_query := l_base_query || ' AND ITEM_INSTANCE_ID IN '
6070: || ' (SELECT CSI_ITEM_INSTANCE_ID FROM AHL_UNIT_CONFIG_HEADERS'

Line 6070: || ' (SELECT CSI_ITEM_INSTANCE_ID FROM AHL_UNIT_CONFIG_HEADERS'

6066: || ' (SELECT CSI_ITEM_INSTANCE_ID FROM AHL_UNIT_CONFIG_HEADERS'
6067: || ' WHERE NAME LIKE ''' || p_demand_Record.Visit_Unit || ''')';
6068: ELSE
6069: l_base_query := l_base_query || ' AND ITEM_INSTANCE_ID IN '
6070: || ' (SELECT CSI_ITEM_INSTANCE_ID FROM AHL_UNIT_CONFIG_HEADERS'
6071: || ' WHERE NAME = ''' || p_demand_Record.Visit_Unit || ''')';
6072: END IF;
6073: END IF;
6074: