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 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 284


        p_x_uf_header_rec.last_updated_by := fnd_global.user_id;

Line: 285


        p_x_uf_header_rec.last_update_date := SYSDATE;

Line: 286


        p_x_uf_header_rec.last_update_login := fnd_global.user_id;

Line: 288


        AHL_UF_HEADERS_PKG.insert_row(
        x_uf_header_id => p_x_uf_header_rec.uf_header_id,
        x_object_version_number => p_x_uf_header_rec.object_version_number,
        x_created_by => p_x_uf_header_rec.created_by,
        x_creation_date => p_x_uf_header_rec.creation_date,
        x_last_updated_by => p_x_uf_header_rec.last_updated_by,
        x_last_update_date => p_x_uf_header_rec.last_update_date,
        x_last_update_login => p_x_uf_header_rec.last_update_login,
        x_unit_config_header_id => p_x_uf_header_rec.unit_config_header_id,
        x_pc_node_id => p_x_uf_header_rec.pc_node_id,
        x_inventory_item_id => p_x_uf_header_rec.inventory_item_id,
        x_inventory_org_id => p_x_uf_header_rec.inventory_org_id,
        x_csi_item_instance_id => p_x_uf_header_rec.csi_item_instance_id,
        x_use_unit_flag => p_x_uf_header_rec.use_unit_flag,
        x_attribute_category => p_x_uf_header_rec.attribute_category,
        x_attribute1 => p_x_uf_header_rec.attribute1,
        x_attribute2 => p_x_uf_header_rec.attribute2,
        x_attribute3 => p_x_uf_header_rec.attribute3,
        x_attribute4 => p_x_uf_header_rec.attribute4,
        x_attribute5 => p_x_uf_header_rec.attribute5,
        x_attribute6 => p_x_uf_header_rec.attribute6,
        x_attribute7 => p_x_uf_header_rec.attribute7,
        x_attribute8 => p_x_uf_header_rec.attribute8,
        x_attribute9 => p_x_uf_header_rec.attribute9,
        x_attribute10 => p_x_uf_header_rec.attribute10,
        x_attribute11 => p_x_uf_header_rec.attribute11,
        x_attribute12 => p_x_uf_header_rec.attribute12,
        x_attribute13 => p_x_uf_header_rec.attribute13,
        x_attribute14 => p_x_uf_header_rec.attribute14,
        x_attribute15 => p_x_uf_header_rec.attribute15
        );

Line: 319


    ELSIF (p_x_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN

        -- setting up object version number
        p_x_uf_header_rec.object_version_number := p_x_uf_header_rec.object_version_number + 1;

Line: 324


        p_x_uf_header_rec.last_updated_by := fnd_global.user_id;

Line: 325


        p_x_uf_header_rec.last_update_date := SYSDATE;

Line: 326


        p_x_uf_header_rec.last_update_login := fnd_global.user_id;

Line: 328


        AHL_UF_HEADERS_PKG.update_row(
        x_uf_header_id => p_x_uf_header_rec.uf_header_id,
        x_object_version_number => p_x_uf_header_rec.object_version_number,
        x_last_updated_by => p_x_uf_header_rec.last_updated_by,
        x_last_update_date => p_x_uf_header_rec.last_update_date,
        x_last_update_login => p_x_uf_header_rec.last_update_login,
        x_unit_config_header_id => p_x_uf_header_rec.unit_config_header_id,
        x_pc_node_id => p_x_uf_header_rec.pc_node_id,
        x_inventory_item_id => p_x_uf_header_rec.inventory_item_id,
        x_inventory_org_id => p_x_uf_header_rec.inventory_org_id,
        x_csi_item_instance_id => p_x_uf_header_rec.csi_item_instance_id,
        x_use_unit_flag => p_x_uf_header_rec.use_unit_flag,
        x_attribute_category => p_x_uf_header_rec.attribute_category,
        x_attribute1 => p_x_uf_header_rec.attribute1,
        x_attribute2 => p_x_uf_header_rec.attribute2,
        x_attribute3 => p_x_uf_header_rec.attribute3,
        x_attribute4 => p_x_uf_header_rec.attribute4,
        x_attribute5 => p_x_uf_header_rec.attribute5,
        x_attribute6 => p_x_uf_header_rec.attribute6,
        x_attribute7 => p_x_uf_header_rec.attribute7,
        x_attribute8 => p_x_uf_header_rec.attribute8,
        x_attribute9 => p_x_uf_header_rec.attribute9,
        x_attribute10 => p_x_uf_header_rec.attribute10,
        x_attribute11 => p_x_uf_header_rec.attribute11,
        x_attribute12 => p_x_uf_header_rec.attribute12,
        x_attribute13 => p_x_uf_header_rec.attribute13,
        x_attribute14 => p_x_uf_header_rec.attribute14,
        x_attribute15 => p_x_uf_header_rec.attribute15
        );

Line: 397


SELECT unit_config_header_id
FROM ahl_unit_config_headers
WHERE name = p_unit_name;

Line: 402


SELECT uf_header_id
FROM ahl_uf_headers
WHERE unit_config_header_id = p_unit_config_header_id;

Line: 451


SELECT inventory_item_id
FROM mtl_system_items_kfv
WHERE concatenated_segments = p_inventory_item_name;

Line: 457


SELECT uf_header_id
FROM ahl_uf_headers
WHERE inventory_item_id = p_inventory_item_id;

Line: 502


SELECT uf_header_id
FROM ahl_uf_headers
WHERE pc_node_id = p_pc_node_id;

Line: 554


    SELECT object_version_number, unit_config_header_id,pc_node_id,inventory_item_id,inventory_org_id,use_unit_flag
    FROM ahl_uf_headers
    WHERE uf_header_id = p_uf_header_id;

Line: 567


    SELECT UCH.unit_config_status_code
    FROM ahl_unit_config_headers UCH
    WHERE (UCH.active_end_date IS NULL OR TRUNC(UCH.active_end_date) > TRUNC(SYSDATE))
    AND UCH.unit_config_header_id = p_unit_config_header_id;

Line: 575


    SELECT 'x'
    FROM mtl_system_items_kfv
    WHERE inventory_item_id = p_inventory_item_id;

Line: 582


    SELECT a.primary_flag,a.status
    FROM ahl_pc_headers_b a, ahl_pc_nodes_b b, ahl_pc_associations c
    WHERE a.pc_header_id = b.pc_header_id AND b.pc_node_id = c.pc_node_id AND
    a.primary_flag = G_PC_PRIMARY_FLAG AND
    a.status = G_COMPLETE_STATUS AND
    c.association_type_flag = p_association_type AND
    c.unit_item_id = p_unit_item_id;

Line: 591


    SELECT a.primary_flag,a.status
    FROM ahl_pc_headers_b a, ahl_pc_nodes_b b
    WHERE a.pc_header_id = b.pc_header_id
    AND b.pc_node_id = p_pc_node_id;

Line: 605


    ELSIF (p_uf_header_rec.operation_flag IS NOT NULL AND p_uf_header_rec.operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
        FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');

Line: 609


            AND (p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)) THEN
        FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');

Line: 838


    SELECT object_version_number, inventory_item_id,csi_item_instance_id,use_unit_flag
    FROM ahl_uf_headers
    WHERE uf_header_id = p_uf_header_id;

Line: 851


    SELECT 'x'
    FROM mtl_system_items_kfv
    WHERE inventory_item_id = p_inventory_item_id;

Line: 858


    SELECT 'x'
    FROM csi_item_instances
    WHERE instance_id = p_csi_item_instance_id;

Line: 868


    ELSIF (p_uf_header_rec.operation_flag IS NOT NULL AND p_uf_header_rec.operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
        FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_HEADER');

Line: 872


            AND (p_uf_header_rec.operation_flag IS NULL OR p_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)) THEN
        FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_UFHID_NLL');

Line: 999


SELECT  unit_config_header_id, inventory_item_id, pc_node_id, inventory_org_id,csi_item_instance_id,
        use_unit_flag, attribute_category, attribute1,attribute2, attribute3,
        attribute4, attribute5, attribute6, attribute7, attribute8, attribute9,
        attribute10, attribute11, attribute12, attribute13, attribute14, attribute15
FROM ahl_uf_headers
WHERE object_version_number= p_object_version_number
AND uf_header_id = p_uf_header_id;

Line: 1010


    IF(p_x_uf_header_rec.operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN
        OPEN uf_header_csr(p_x_uf_header_rec.uf_header_id, p_x_uf_header_rec.object_version_number);

Line: 1256


        IF(p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_DELETE) THEN
            AHL_UF_DETAILS_PKG.delete_row(p_x_uf_details_tbl(i).uf_detail_id);

Line: 1262


        IF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN

           --setting object version number for create
           p_x_uf_details_tbl(i).object_version_number := p_x_uf_details_tbl(i).object_version_number + 1;

Line: 1267


           p_x_uf_details_tbl(i).last_updated_by := fnd_global.user_id;

Line: 1268


           p_x_uf_details_tbl(i).last_update_date := SYSDATE;

Line: 1269


           p_x_uf_details_tbl(i).last_update_login := fnd_global.user_id;

Line: 1271


           AHL_UF_DETAILS_PKG.update_row(
           x_uf_detail_id => p_x_uf_details_tbl(i).uf_detail_id,
           x_object_version_number => p_x_uf_details_tbl(i).object_version_number,
           x_last_updated_by => p_x_uf_details_tbl(i).last_updated_by,
           x_last_update_date => p_x_uf_details_tbl(i).last_update_date,
           x_last_update_login => p_x_uf_details_tbl(i).last_update_login,
           x_uf_header_id => p_x_uf_details_tbl(i).uf_header_id,
           x_uom_code => p_x_uf_details_tbl(i).uom_code,
           x_start_date => p_x_uf_details_tbl(i).start_date,
           x_end_date => p_x_uf_details_tbl(i).end_date,
           x_usage_per_day => p_x_uf_details_tbl(i).usage_per_day,
           x_attribute_category => p_x_uf_details_tbl(i).attribute_category,
           x_attribute1 => p_x_uf_details_tbl(i).attribute1,
           x_attribute2 => p_x_uf_details_tbl(i).attribute2,
           x_attribute3 => p_x_uf_details_tbl(i).attribute3,
           x_attribute4 => p_x_uf_details_tbl(i).attribute4,
           x_attribute5 => p_x_uf_details_tbl(i).attribute5,
           x_attribute6 => p_x_uf_details_tbl(i).attribute6,
           x_attribute7 => p_x_uf_details_tbl(i).attribute7,
           x_attribute8 => p_x_uf_details_tbl(i).attribute8,
           x_attribute9 => p_x_uf_details_tbl(i).attribute9,
           x_attribute10 => p_x_uf_details_tbl(i).attribute10,
           x_attribute11 => p_x_uf_details_tbl(i).attribute11,
           x_attribute12 => p_x_uf_details_tbl(i).attribute12,
           x_attribute13 => p_x_uf_details_tbl(i).attribute13,
           x_attribute14 => p_x_uf_details_tbl(i).attribute14,
           x_attribute15 => p_x_uf_details_tbl(i).attribute15
           );

Line: 1308


           p_x_uf_details_tbl(i).last_updated_by := fnd_global.user_id;

Line: 1309


           p_x_uf_details_tbl(i).last_update_date := SYSDATE;

Line: 1310


           p_x_uf_details_tbl(i).last_update_login := fnd_global.user_id;

Line: 1314


           AHL_UF_DETAILS_PKG.insert_row(
           x_uf_detail_id => p_x_uf_details_tbl(i).uf_detail_id,
           x_object_version_number => p_x_uf_details_tbl(i).object_version_number,
           x_created_by => p_x_uf_details_tbl(i).created_by,
           x_creation_date => p_x_uf_details_tbl(i).creation_date,
           x_last_updated_by => p_x_uf_details_tbl(i).last_updated_by,
           x_last_update_date => p_x_uf_details_tbl(i).last_update_date,
           x_last_update_login => p_x_uf_details_tbl(i).last_update_login,
           x_uf_header_id => p_x_uf_details_tbl(i).uf_header_id,
           x_uom_code => p_x_uf_details_tbl(i).uom_code,
           x_start_date => p_x_uf_details_tbl(i).start_date,
           x_end_date => p_x_uf_details_tbl(i).end_date,
           x_usage_per_day => p_x_uf_details_tbl(i).usage_per_day,
           x_attribute_category => p_x_uf_details_tbl(i).attribute_category,
           x_attribute1 => p_x_uf_details_tbl(i).attribute1,
           x_attribute2 => p_x_uf_details_tbl(i).attribute2,
           x_attribute3 => p_x_uf_details_tbl(i).attribute3,
           x_attribute4 => p_x_uf_details_tbl(i).attribute4,
           x_attribute5 => p_x_uf_details_tbl(i).attribute5,
           x_attribute6 => p_x_uf_details_tbl(i).attribute6,
           x_attribute7 => p_x_uf_details_tbl(i).attribute7,
           x_attribute8 => p_x_uf_details_tbl(i).attribute8,
           x_attribute9 => p_x_uf_details_tbl(i).attribute9,
           x_attribute10 => p_x_uf_details_tbl(i).attribute10,
           x_attribute11 => p_x_uf_details_tbl(i).attribute11,
           x_attribute12 => p_x_uf_details_tbl(i).attribute12,
           x_attribute13 => p_x_uf_details_tbl(i).attribute13,
           x_attribute14 => p_x_uf_details_tbl(i).attribute14,
           x_attribute15 => p_x_uf_details_tbl(i).attribute15
           );

Line: 1381


 SELECT object_version_number, uf_header_id,uom_code,start_date,end_date,usage_per_day
 FROM ahl_uf_details
 WHERE uf_detail_id = p_uf_detail_id;

Line: 1396


 select 'x'
 from mtl_units_of_measure_vl
 where uom_code = p_uom_code;

Line: 1401


 select 'x'
 from mtl_units_of_measure_vl
 where uom_code = p_uom_code;

Line: 1406


 select 'x'
 from mtl_units_of_measure_vl
 where uom_code = p_uom_code;

Line: 1416


       IF ( p_x_uf_details_tbl(i).operation_flag IS NOT NULL AND p_x_uf_details_tbl(i).operation_flag NOT IN(AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE,AHL_UMP_UF_PVT.G_OP_DELETE))THEN
           FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INVOP_DETAIL');

Line: 1470


       IF(p_x_uf_details_tbl(i).operation_flag IN (AHL_UMP_UF_PVT.G_OP_CREATE,AHL_UMP_UF_PVT.G_OP_UPDATE))THEN
         -- checking for start and end dates
         IF(p_x_uf_details_tbl(i).start_date IS NULL) THEN
            FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_INV_SDATE_NLL');

Line: 1497


            ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN
              IF ( TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) AND
                  (TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date) OR
                 p_x_uf_details_tbl(i).uom_code <> l_uom_code))  THEN
                 FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');

Line: 1519


            ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN
              IF ( TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) AND
                  (TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date) OR
                 p_x_uf_details_tbl(i).uom_code <> l_uom_code))  THEN
                 FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');

Line: 1542


           IF (p_uf_header_rec.forecast_type = AHL_UMP_UF_PVT.G_OP_UPDATE)THEN
                OPEN unit_uom_code_ckeck_csr(p_x_uf_details_tbl(i).uom_code);

Line: 1584


       IF(p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE)THEN
           IF TRUNC(p_x_uf_details_tbl(i).start_date) < TRUNC(SYSDATE) THEN
               IF((TRUNC(p_x_uf_details_tbl(i).start_date) <> TRUNC(l_start_date))OR
                   (p_x_uf_details_tbl(i).uom_code <> l_uom_code))  THEN
                    FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_UMP_UF_DONCHG_STD_UOM');

Line: 1612


       ELSIF (p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_DELETE)THEN
           IF(TRUNC(l_start_date) < TRUNC(SYSDATE))THEN
                p_x_uf_details_tbl(i).start_date := l_start_date;

Line: 1618


                p_x_uf_details_tbl(i).operation_flag := AHL_UMP_UF_PVT.G_OP_UPDATE;

Line: 1645


    SELECT object_version_number, uf_detail_id, uf_header_id,uom_code,start_date,end_date,usage_per_day
    FROM ahl_uf_details
    WHERE uf_header_id = p_uf_header_id
    AND (end_date IS NULL OR TRUNC(end_date) >= TRUNC(SYSDATE))
    ORDER BY uom_code,start_date;

Line: 1720


SELECT uf_header_id,end_date,attribute_category, attribute1,attribute2, attribute3, attribute4,
     attribute5, attribute6, attribute7, attribute8, attribute9, attribute10, attribute11,
     attribute12, attribute13, attribute14, attribute15
FROM ahl_uf_details
WHERE object_version_number= p_object_version_number
AND uf_detail_id = p_uf_detail_id;

Line: 1731


    IF(p_x_uf_details_tbl(i).operation_flag = AHL_UMP_UF_PVT.G_OP_UPDATE) THEN
        OPEN uf_details_csr(p_x_uf_details_tbl(i).uf_detail_id, p_x_uf_details_tbl(i).object_version_number);

Line: 1921


    SELECT 'x'
    FROM ahl_uf_details WHERE uf_header_id = p_uf_header_id;

Line: 1932


         AHL_UF_HEADERS_PKG.delete_row(p_uf_header_rec.uf_header_id);

Line: 1960


   SELECT  unit_config_header_id
    FROM    ahl_unit_config_headers
    WHERE   name = c_unit_name;

Line: 1965


   SELECT  inventory_item_id
    FROM    mtl_system_items_kfv
    WHERE   concatenated_segments = c_part_number;

Line: 1973


   SELECT a.pc_node_id
    FROM  ahl_pc_associations a, ahl_pc_nodes_b b, ahl_pc_headers_b c
    WHERE   a.unit_item_id = c_unit_config_header_id
      AND   a.association_type_flag = c_type
      AND   a.pc_node_id = b.pc_node_id
      AND   b.pc_header_id = c.pc_header_id
      AND   c.primary_flag = c_primary_flag
      AND   c.status = c_complete_status;

Line: 1983


    SELECT a.inventory_item_id
      FROM csi_item_instances a, ahl_unit_config_headers b
     WHERE a.instance_id = b.csi_item_instance_id
       AND b.unit_config_header_id = c_uc_header_id;

Line: 1991


  SELECT 'x'
    FROM   ahl_pc_nodes_b a, ahl_pc_headers_b b
    WHERE   a.pc_node_id = p_pc_node_id
      AND   a.pc_header_id = b.pc_header_id
      AND   b.primary_flag = c_primary_flag
      AND   b.status = c_complete_status;

Line: 1999


   SELECT  pc_node_id
    FROM    ahl_pc_nodes_b
    START WITH pc_node_id = c_pc_id
    CONNECT BY pc_node_id = PRIOR parent_node_id;

Line: 2005


   SELECT  distinct a.uom_code
    FROM    ahl_uf_details a, ahl_uf_headers b
    WHERE a.uf_header_id = b.uf_header_id
     AND  b.pc_node_id = c_pc_id;

Line: 2011


   SELECT  a.UF_DETAIL_ID,
 	   a.OBJECT_VERSION_NUMBER,
           a.LAST_UPDATE_DATE   ,
           a.LAST_UPDATED_BY    ,
           a.CREATION_DATE      ,
           a.CREATED_BY         ,
           a.LAST_UPDATE_LOGIN  ,
           a.UF_HEADER_ID       ,
           a.UOM_CODE           ,
           a.START_DATE         ,
           a.END_DATE           ,
           a.USAGE_PER_DAY      ,
           a.ATTRIBUTE_CATEGORY ,
           a.ATTRIBUTE1  ,
           a.ATTRIBUTE2  ,
           a.ATTRIBUTE3  ,
           a.ATTRIBUTE4  ,
           a.ATTRIBUTE5  ,
           a.ATTRIBUTE6  ,
           a.ATTRIBUTE7  ,
           a.ATTRIBUTE8  ,
           a.ATTRIBUTE9  ,
           a.ATTRIBUTE10 ,
           a.ATTRIBUTE11 ,
           a.ATTRIBUTE12 ,
           a.ATTRIBUTE13 ,
           a.ATTRIBUTE14 ,
           a.ATTRIBUTE15
    FROM    ahl_uf_details a, ahl_uf_headers b
    WHERE a.uom_code = p_uom_code
     AND  b.pc_node_id = c_pc_id
     AND a.uf_header_id = b.uf_header_id;

Line: 2045


   SELECT  a.UF_DETAIL_ID,
 	   a.OBJECT_VERSION_NUMBER,
           a.LAST_UPDATE_DATE   ,
           a.LAST_UPDATED_BY    ,
           a.CREATION_DATE      ,
           a.CREATED_BY         ,
           a.LAST_UPDATE_LOGIN  ,
           a.UF_HEADER_ID       ,
           a.UOM_CODE           ,
           a.START_DATE         ,
           a.END_DATE           ,
           a.USAGE_PER_DAY      ,
           a.ATTRIBUTE_CATEGORY ,
           a.ATTRIBUTE1  ,
           a.ATTRIBUTE2  ,
           a.ATTRIBUTE3  ,
           a.ATTRIBUTE4  ,
           a.ATTRIBUTE5  ,
           a.ATTRIBUTE6  ,
           a.ATTRIBUTE7  ,
           a.ATTRIBUTE8  ,
           a.ATTRIBUTE9  ,
           a.ATTRIBUTE10 ,
           a.ATTRIBUTE11 ,
           a.ATTRIBUTE12 ,
           a.ATTRIBUTE13 ,
           a.ATTRIBUTE14 ,
           a.ATTRIBUTE15
    FROM    ahl_uf_details a, ahl_uf_headers b
    WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
     AND a.uf_header_id = b.uf_header_id
     AND a.uom_code = p_uom_code
     AND  b.pc_node_id = p_pc_id;

Line: 2081


   SELECT  distinct a.uom_code
   FROM    ahl_uf_details a, ahl_uf_headers b
   WHERE a.uf_header_id = b.uf_header_id
      AND  b.inventory_item_id = p_inventory_item_id;

Line: 2089


   SELECT  a.UF_DETAIL_ID,
 	   a.OBJECT_VERSION_NUMBER,
           a.LAST_UPDATE_DATE   ,
           a.LAST_UPDATED_BY    ,
           a.CREATION_DATE      ,
           a.CREATED_BY         ,
           a.LAST_UPDATE_LOGIN  ,
           a.UF_HEADER_ID       ,
           a.UOM_CODE           ,
           a.START_DATE         ,
           a.END_DATE           ,
           a.USAGE_PER_DAY      ,
           a.ATTRIBUTE_CATEGORY ,
           a.ATTRIBUTE1  ,
           a.ATTRIBUTE2  ,
           a.ATTRIBUTE3  ,
           a.ATTRIBUTE4  ,
           a.ATTRIBUTE5  ,
           a.ATTRIBUTE6  ,
           a.ATTRIBUTE7  ,
           a.ATTRIBUTE8  ,
           a.ATTRIBUTE9  ,
           a.ATTRIBUTE10 ,
           a.ATTRIBUTE11 ,
           a.ATTRIBUTE12 ,
           a.ATTRIBUTE13 ,
           a.ATTRIBUTE14 ,
           a.ATTRIBUTE15
    FROM    ahl_uf_details a, ahl_uf_headers b
    WHERE a.uf_header_id = b.uf_header_id
     AND a.uom_code = p_uom_code
     AND  b.inventory_item_id = p_inventory_item_id;

Line: 2126


   SELECT  a.UF_DETAIL_ID,
 	   a.OBJECT_VERSION_NUMBER,
           a.LAST_UPDATE_DATE   ,
           a.LAST_UPDATED_BY    ,
           a.CREATION_DATE      ,
           a.CREATED_BY         ,
           a.LAST_UPDATE_LOGIN  ,
           a.UF_HEADER_ID       ,
           a.UOM_CODE           ,
           a.START_DATE         ,
           a.END_DATE           ,
           a.USAGE_PER_DAY      ,
           a.ATTRIBUTE_CATEGORY ,
           a.ATTRIBUTE1  ,
           a.ATTRIBUTE2  ,
           a.ATTRIBUTE3  ,
           a.ATTRIBUTE4  ,
           a.ATTRIBUTE5  ,
           a.ATTRIBUTE6  ,
           a.ATTRIBUTE7  ,
           a.ATTRIBUTE8  ,
           a.ATTRIBUTE9  ,
           a.ATTRIBUTE10 ,
           a.ATTRIBUTE11 ,
           a.ATTRIBUTE12 ,
           a.ATTRIBUTE13 ,
           a.ATTRIBUTE14 ,
           a.ATTRIBUTE15
    FROM    ahl_uf_details a, ahl_uf_headers b
    WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
    AND a.uf_header_id = b.uf_header_id
     AND a.uom_code = p_uom_code
     AND  b.inventory_item_id = p_inventory_item_id;

Line: 2162


   SELECT  distinct a.uom_code
   FROM    ahl_uf_details a, ahl_uf_headers b
   WHERE a.uf_header_id = b.uf_header_id
      AND  b.unit_config_header_id = p_unit_config_id;

Line: 2170


   SELECT  a.UF_DETAIL_ID,
 	   a.OBJECT_VERSION_NUMBER,
           a.LAST_UPDATE_DATE   ,
           a.LAST_UPDATED_BY    ,
           a.CREATION_DATE      ,
           a.CREATED_BY         ,
           a.LAST_UPDATE_LOGIN  ,
           a.UF_HEADER_ID       ,
           a.UOM_CODE           ,
           a.START_DATE         ,
           a.END_DATE           ,
           a.USAGE_PER_DAY      ,
           a.ATTRIBUTE_CATEGORY ,
           a.ATTRIBUTE1  ,
           a.ATTRIBUTE2  ,
           a.ATTRIBUTE3  ,
           a.ATTRIBUTE4  ,
           a.ATTRIBUTE5  ,
           a.ATTRIBUTE6  ,
           a.ATTRIBUTE7  ,
           a.ATTRIBUTE8  ,
           a.ATTRIBUTE9  ,
           a.ATTRIBUTE10 ,
           a.ATTRIBUTE11 ,
           a.ATTRIBUTE12 ,
           a.ATTRIBUTE13 ,
           a.ATTRIBUTE14 ,
           a.ATTRIBUTE15
    FROM    ahl_uf_details a, ahl_uf_headers b
    WHERE a.uf_header_id = b.uf_header_id
     AND a.uom_code = p_uom_code
     AND  b.unit_config_header_id = p_unit_config_id;

Line: 2207


   SELECT  a.UF_DETAIL_ID,
 	   a.OBJECT_VERSION_NUMBER,
           a.LAST_UPDATE_DATE   ,
           a.LAST_UPDATED_BY    ,
           a.CREATION_DATE      ,
           a.CREATED_BY         ,
           a.LAST_UPDATE_LOGIN  ,
           a.UF_HEADER_ID       ,
           a.UOM_CODE           ,
           a.START_DATE         ,
           a.END_DATE           ,
           a.USAGE_PER_DAY      ,
           a.ATTRIBUTE_CATEGORY ,
           a.ATTRIBUTE1  ,
           a.ATTRIBUTE2  ,
           a.ATTRIBUTE3  ,
           a.ATTRIBUTE4  ,
           a.ATTRIBUTE5  ,
           a.ATTRIBUTE6  ,
           a.ATTRIBUTE7  ,
           a.ATTRIBUTE8  ,
           a.ATTRIBUTE9  ,
           a.ATTRIBUTE10 ,
           a.ATTRIBUTE11 ,
           a.ATTRIBUTE12 ,
           a.ATTRIBUTE13 ,
           a.ATTRIBUTE14 ,
           a.ATTRIBUTE15
    FROM    ahl_uf_details a, ahl_uf_headers b
    WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
    AND a.uf_header_id = b.uf_header_id
    AND a.uom_code = p_uom_code
    AND  b.unit_config_header_id = p_unit_config_id;

Line: 2353


              l_UF_details_rec.LAST_UPDATE_DATE   := l_temp_details_rec.LAST_UPDATE_DATE ;

Line: 2354


              l_UF_details_rec.LAST_UPDATED_BY    := l_temp_details_rec.LAST_UPDATED_BY ;

Line: 2357


              l_UF_details_rec.LAST_UPDATE_LOGIN  := l_temp_details_rec.LAST_UPDATE_LOGIN ;

Line: 2391


              l_UF_details_rec.LAST_UPDATE_DATE   := l_temp_details_rec.LAST_UPDATE_DATE ;

Line: 2392


              l_UF_details_rec.LAST_UPDATED_BY    := l_temp_details_rec.LAST_UPDATED_BY ;

Line: 2395


              l_UF_details_rec.LAST_UPDATE_LOGIN  := l_temp_details_rec.LAST_UPDATE_LOGIN ;

Line: 2458


              l_UF_details_rec.LAST_UPDATE_DATE   := l_temp_details_rec.LAST_UPDATE_DATE ;

Line: 2459


              l_UF_details_rec.LAST_UPDATED_BY    := l_temp_details_rec.LAST_UPDATED_BY ;

Line: 2462


              l_UF_details_rec.LAST_UPDATE_LOGIN  := l_temp_details_rec.LAST_UPDATE_LOGIN ;

Line: 2496


              l_UF_details_rec.LAST_UPDATE_DATE   := l_temp_details_rec.LAST_UPDATE_DATE ;

Line: 2497


              l_UF_details_rec.LAST_UPDATED_BY    := l_temp_details_rec.LAST_UPDATED_BY ;

Line: 2500


              l_UF_details_rec.LAST_UPDATE_LOGIN  := l_temp_details_rec.LAST_UPDATE_LOGIN ;

Line: 2571


            l_UF_details_rec.LAST_UPDATE_DATE   := l_temp_details_rec.LAST_UPDATE_DATE ;

Line: 2572


            l_UF_details_rec.LAST_UPDATED_BY    := l_temp_details_rec.LAST_UPDATED_BY ;

Line: 2575


            l_UF_details_rec.LAST_UPDATE_LOGIN  := l_temp_details_rec.LAST_UPDATE_LOGIN ;

Line: 2609


            l_UF_details_rec.LAST_UPDATE_DATE   := l_temp_details_rec.LAST_UPDATE_DATE ;

Line: 2610


            l_UF_details_rec.LAST_UPDATED_BY    := l_temp_details_rec.LAST_UPDATED_BY ;

Line: 2613


            l_UF_details_rec.LAST_UPDATE_LOGIN  := l_temp_details_rec.LAST_UPDATE_LOGIN ;

Line: 2664


   SELECT  a.UF_DETAIL_ID,
 	   a.OBJECT_VERSION_NUMBER,
           a.LAST_UPDATE_DATE   ,
           a.LAST_UPDATED_BY    ,
           a.CREATION_DATE      ,
           a.CREATED_BY         ,
           a.LAST_UPDATE_LOGIN  ,
           a.UF_HEADER_ID       ,
           a.UOM_CODE           ,
           a.START_DATE         ,
           a.END_DATE           ,
           a.USAGE_PER_DAY      ,
           a.ATTRIBUTE_CATEGORY ,
           a.ATTRIBUTE1  ,
           a.ATTRIBUTE2  ,
           a.ATTRIBUTE3  ,
           a.ATTRIBUTE4  ,
           a.ATTRIBUTE5  ,
           a.ATTRIBUTE6  ,
           a.ATTRIBUTE7  ,
           a.ATTRIBUTE8  ,
           a.ATTRIBUTE9  ,
           a.ATTRIBUTE10 ,
           a.ATTRIBUTE11 ,
           a.ATTRIBUTE12 ,
           a.ATTRIBUTE13 ,
           a.ATTRIBUTE14 ,
           a.ATTRIBUTE15
    FROM    ahl_uf_details a, ahl_uf_headers b,csi_item_instances c
    WHERE a.uf_header_id = b.uf_header_id
     AND  b.inventory_item_id = c.inventory_item_id
     AND  c.instance_id = p_csi_item_instance_id;

Line: 2698


   SELECT  a.UF_DETAIL_ID,
 	   a.OBJECT_VERSION_NUMBER,
           a.LAST_UPDATE_DATE   ,
           a.LAST_UPDATED_BY    ,
           a.CREATION_DATE      ,
           a.CREATED_BY         ,
           a.LAST_UPDATE_LOGIN  ,
           a.UF_HEADER_ID       ,
           a.UOM_CODE           ,
           a.START_DATE         ,
           a.END_DATE           ,
           a.USAGE_PER_DAY      ,
           a.ATTRIBUTE_CATEGORY ,
           a.ATTRIBUTE1  ,
           a.ATTRIBUTE2  ,
           a.ATTRIBUTE3  ,
           a.ATTRIBUTE4  ,
           a.ATTRIBUTE5  ,
           a.ATTRIBUTE6  ,
           a.ATTRIBUTE7  ,
           a.ATTRIBUTE8  ,
           a.ATTRIBUTE9  ,
           a.ATTRIBUTE10 ,
           a.ATTRIBUTE11 ,
           a.ATTRIBUTE12 ,
           a.ATTRIBUTE13 ,
           a.ATTRIBUTE14 ,
           a.ATTRIBUTE15
    FROM    ahl_uf_details a, ahl_uf_headers b,csi_item_instances c
    WHERE (a.end_date IS NULL OR TRUNC(a.end_date) >= TRUNC(p_onward_end_date))
     AND a.uf_header_id = b.uf_header_id
     AND  b.inventory_item_id = c.inventory_item_id
     AND  c.instance_id = p_csi_item_instance_id;

Line: 2757


       l_UF_details_rec.LAST_UPDATE_DATE   := l_temp_details_rec.LAST_UPDATE_DATE ;

Line: 2758


       l_UF_details_rec.LAST_UPDATED_BY    := l_temp_details_rec.LAST_UPDATED_BY ;

Line: 2761


       l_UF_details_rec.LAST_UPDATE_LOGIN  := l_temp_details_rec.LAST_UPDATE_LOGIN ;

Line: 2795


       l_UF_details_rec.LAST_UPDATE_DATE   := l_temp_details_rec.LAST_UPDATE_DATE ;

Line: 2796


       l_UF_details_rec.LAST_UPDATED_BY    := l_temp_details_rec.LAST_UPDATED_BY ;

Line: 2799


       l_UF_details_rec.LAST_UPDATE_LOGIN  := l_temp_details_rec.LAST_UPDATE_LOGIN ;